nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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

Find more posts tagged with

Comments

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.