topic Re: Database: readable files per user in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/database-readable-files-per-user/m-p/297549#M250679 <HTML><HEAD></HEAD><BODY><P>Why don't you use one of the provided APIs like CMIS our FTS?</P><P>If you need the result in a specific format, you can even develop a webscript for that.</P></BODY></HTML> Fri, 23 Dec 2016 00:13:54 GMT douglascrp 2016-12-23T00:13:54Z Database: readable files per user https://connect.hyland.com/t5/alfresco-archive/database-readable-files-per-user/m-p/297547#M250677 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&nbsp;(both identified by their node_id).I have also Tue, 20 Dec 2016 16:40:55 GMT https://connect.hyland.com/t5/alfresco-archive/database-readable-files-per-user/m-p/297547#M250677 alaindichiappar 2016-12-20T16:40:55Z Re: Database: readable files per user https://connect.hyland.com/t5/alfresco-archive/database-readable-files-per-user/m-p/297548#M250678 <HTML><HEAD></HEAD><BODY><P>In my opinion&nbsp;it is very difficult even impossible for you to do that from database.</P><P>Permissions can be inherited from/override the parent folder,it will be very difficult for you to evaluate read permission directly.</P></BODY></HTML> Tue, 20 Dec 2016 17:11:53 GMT https://connect.hyland.com/t5/alfresco-archive/database-readable-files-per-user/m-p/297548#M250678 kaynezhang 2016-12-20T17:11:53Z Re: Database: readable files per user https://connect.hyland.com/t5/alfresco-archive/database-readable-files-per-user/m-p/297549#M250679 <HTML><HEAD></HEAD><BODY><P>Why don't you use one of the provided APIs like CMIS our FTS?</P><P>If you need the result in a specific format, you can even develop a webscript for that.</P></BODY></HTML> Fri, 23 Dec 2016 00:13:54 GMT https://connect.hyland.com/t5/alfresco-archive/database-readable-files-per-user/m-p/297549#M250679 douglascrp 2016-12-23T00:13:54Z