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 permissions. Can I get all these permissions for database? And which tables do I need to find that out.
Here are related query for your reference:
https://www.sqlservercentral.com/Forums/Topic1560182-1550-1.aspx
- That's not what was asked. The OP wants to get SharePoint permissions, not database user permissions. But at the same time, it's not supported to query the database directly.
- 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.
