Page 1 of 1

How to find all folders on which a user has permissions

PostPosted:Thu Oct 09, 2014 8:05 am
by cimalink
Hello all,

I'm looking for a way to find all folders on which a specific user has permissions.
I actually have around 150 users in openKM, sometimes one worker is replaced by another one in the company.
i need an easy way to find all the folders for which let's say user10 has read permission.

Thanks

Re: How to find all folders on which a user has permissions

PostPosted:Fri Oct 10, 2014 10:23 am
by jllort
There's a report that could use or modify for it DocumentsAccessibleByUserOrdered.jrxml available at http://wiki.openkm.com/index.php/Reports_Packs

Also you can create your own based on database query tables OKM_NODE_DOCUMENT ( or OKM_NODE_BASE ) and table OKM_ROLE_PERMISSIONS and OKM_USER_PERMISSIONS ( doing some query you can get the exact information you need ).