Database: readable files per user

[alaindichiappar]

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

[kaynezhang]

In my opinion it is very difficult even impossible for you to do that from database.

Permissions can be inherited from/override the parent folder,it will be very difficult for you to evaluate read permission directly.

[douglascrp]

Why don't you use one of the provided APIs like CMIS our FTS?

If you need the result in a specific format, you can even develop a webscript for that.