Forum Discussion
User permissions in database
I'm looking for an SQL query to find out the several user permissions in database. Within Saherpoint per site it's possible to view the permissions. Several sites have a lot of specific additional pe...
You shouldn't ever be querying a SharePoint database. If you need a broad permissions report, I'd suggest looking into 3rd party tools such as Sharegate or SPDocKit.
These tools look quit expensive. The only thing I want is to run a report each three months to find out the several permissions in Sharepoint en do something with it.
Are there more tools available to do that?
Nothing I'm aware of that is free. Since these tools use the SharePoint APIs, you could develop a PowerShell script for it, but this would be computationally expensive, depending on the site and complexity of your sites. There are options like https://gallery.technet.microsoft.com/office/Enumerate-SharePoint-2010-35976bdb, but I think even that doesn't go to the depth you're after.