AnsweredAssumed Answered

Database: readable files per user

Question asked by alaindichiappari on Dec 20, 2016
Latest reply on Dec 23, 2016 by douglascrp

Hi everyone, i need to extract directly from the database (postgresql) the list of every file accessible from a specific user (at least read permission).
Currently i have a query to extract all the information that i need for the users and for the files (both identified by their node_id).

I have also considered alf_access_control_list as interesting table for what i need, but i lack of the conjuction to get the result i'm looking for.

 

Thanks

Outcomes