I need sql query for each folder - user details and level of access. Kindly help us.
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.
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?
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.
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.
I need simple SQL Query - if it possible for each folder who have access and what kind of access. Please help me out
Again, a "simple" SQL query is not possible...
Can i get the list in excel format. each folder who have access . what kind of access. In community Edition.
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.
Retrieving data ...