topic Re: Pls provide me a query for the access details (User details and level of access) for all the folders in Alfresco Forum

Pls provide me a query for the access details (User details and level of access) for all the folders

abiram2008raj — Thu, 17 Aug 2017 12:52:39 GMT

I need sql query for each folder - user details and level of access. Kindly help us.

Re: Pls provide me a query for the access details (User details and level of access) for all the folders

afaust — Thu, 17 Aug 2017 20:46:28 GMT

There is no such thing. Access level permissions and their data management is so extremely abstracted that you cannot retrieve the information easily with a few SQL queries. It takes a lot of complex processing to get the information you need.

Re: Pls provide me a query for the access details (User details and level of access) for all the folders

fcorti — Fri, 18 Aug 2017 13:56:39 GMT

Hi Abiram,

Axel is right and gave you the answer.
One clarification from my side: your goal is to retrieve the data and you want to know "who can do what" or are you looking for a query to "update" the permits?

Re: Pls provide me a query for the access details (User details and level of access) for all the folders

abiram2008raj — Mon, 21 Aug 2017 06:07:40 GMT

Hi Corti,

I need select query. I tell a example one folder name called "Sample". In that sample folder we gave access for lot of users. Right now i want who are the people have access in that folder and what kind of access they have like Manager , Collaborator some thing . i think this is possible. Please provide me a update.

Re: Pls provide me a query for the access details (User details and level of access) for all the folders

afaust — Mon, 21 Aug 2017 06:35:26 GMT

For one folder you can simply use the Alfresco (Script) API to get the data without having to write a SQL against the database. E.g. use the JavaScript Console addon to write a JavaScript, resolve the folder node, access its permissions and print out the data you want via the "print" function that the JavaScript Console provides. Of course you can do this without the JavaScript Console by just writing a JavaScript-backed web script and render the results via FreeMarker.

The problematic / hard thing to do is getting this kind of data for a bulk set of nodes, which your original question suggested ("for each folder") - for single or a few nodes the API is sufficient - it just does not scale well in terms of performance to more than a few dozen nodes per transaction / request.

Re: Pls provide me a query for the access details (User details and level of access) for all the folders

abiram2008raj — Mon, 21 Aug 2017 06:40:00 GMT

Yes if it possible for each folder who have access and what kind of access. Sql is very helpful then javascript. I m not that much aware of JS. if possible share sql for each folder or bulk folder.

Re: Pls provide me a query for the access details (User details and level of access) for all the folders

abiram2008raj — Wed, 23 Aug 2017 12:23:46 GMT

I need simple SQL Query - if it possible for each folder who have access and what kind of access. Please help me out

Re: Pls provide me a query for the access details (User details and level of access) for all the folders

afaust — Wed, 23 Aug 2017 12:38:03 GMT

Again, a "simple" SQL query is not possible...

Re: Pls provide me a query for the access details (User details and level of access) for all the folders

abiram2008raj — Wed, 23 Aug 2017 12:42:38 GMT

I need select query for one folder no Javascript. I tell a example one folder name called "Sample". In that sample folder we gave access for lot of users. Right now i want who are the people have access in that folder and what kind of access they have like Manager , Collaborator some thing . i think this is possible. Please provide me a update.

Re: Pls provide me a query for the access details (User details and level of access) for all the folders

abiram2008raj — Wed, 23 Aug 2017 13:58:48 GMT

Can i get the list in excel format. each folder who have access . what kind of access. In community Edition.

Re: Pls provide me a query for the access details (User details and level of access) for all the folders

jpotts — Thu, 24 Aug 2017 14:16:14 GMT

There is nothing available out of the box that does exactly what you want so you're going to have to roll up your sleeves and do the work.

Axel gave you a great answer detailing how to do it. Please try it out and report back with the specific area that gives you trouble.