How to get security permission details on site level - sharepoint 2013


How to get security permission details on site level

Example: in our site we have around 20 document libraries I want to generate the report which user has and what level of permission on each document library. Please advice

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rainer JeschorCommented:
are you really sure that you want to generate this kind of report?

Imagine someone added the domain group "Domain User", then this report will have to list each and every user of the domain.

Or do you want to simply get the list of security assignment and list groups as groups (and not expanding the group membership on user level)?

Thanks for clarification.

Just my 2ct
tabreedAuthor Commented:
Hi Rainer,

yes we would like to generate site level and since our each department have their own site the user will be approximately  50 to 60 per site.

Rainer JeschorCommented:
is this for SharePoint 2013 on premise or SharePoint online?

IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

tabreedAuthor Commented:
SharePoint 2013 on premise

in the permissions settings for an item, you can check the effective permissions for a user and it shown you the permissions for this user and also visible the permissions, the user has on other items.

For a complete report, you may check the script from MS, which you can find here:
tabreedAuthor Commented:
Thanks Bembi, but I am looking PowerShell script to generate permissions report on each document library in a site. please advice
OK, have also a look here....

Copy the code into a file, i.e. named SPGetPermissions.ps1
Goto SP Management Shell, start the script...
You will be asked for URL and Target Path.

Import the CSV into Excel...
Now you can filter the list for all ObjectTypes (or Users or whatever) you want to see, with the users and permissions levels...

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
tabreedAuthor Commented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.