How to run a full SharePoint permissions audit with Smart Permissions (free)
Most SharePoint permission audits fail the same way: someone runs a PowerShell script for two hours, gets 20,000 rows back, and nothing happens for a quarter because the output is a wall of raw ACLs with no plan attached. This is the workflow we run on client sites — it's short, it's repeatable, and every step ends in an artifact you can hand to an auditor.
The tool is the free SharePoint Smart Permissions SPFx web part. It's read-only — it reports, it doesn't rewrite ACLs — which is exactly what you want in the discovery phase. Remediation happens in the SharePoint UI or PnP PowerShell after review.
Step 1 — Scope
Before running anything, agree three things with the site owner:
- Which site. One site per audit run. A hub with 40 associated sites is 40 audits, not one — group members and role assignments don't cross site collections cleanly.
- Depth. Site + lists is enough for a "who has Edit here" review. Add folders and items when the question is Copilot readiness or when there's a known oversharing incident.
- Reason. Copilot readiness, offboarding sweep, quarterly governance, external audit. The reason drives which columns matter in the export.
Step 2 — Configure and run the report
Add the Smart Permissions web part to a page on the target site. In web part settings, turn on:
- Expand group members — every SharePoint group, Microsoft 365 Group, and Entra security group is flattened to individual users. This is what makes the report answer "who can edit" instead of "which groups have Edit."
- Include item-level scopes — folders and items with unique permissions get their own rows. Skip only if you already know the site is fully inherited.
- Show inheritance state — every scope is tagged Inherited or Unique. This is the primary filter in the review.
Run the report. Wait for the crawl to finish (a few minutes for most sites, longer for libraries with 10k+ items).
Step 3 — Export to Excel
Click Export to Excel. The workbook has one row per user per scope, with columns for Scope path, Scope type (Site / List / Folder / Item), Inheritance (Inherited / Unique), Principal, Source group, and Role assignment.
Filter the workbook to Inheritance = Unique. Everything else is inherited and will collapse the moment you fix the parent — it's noise for cleanup purposes. Unique rows are typically 5–15% of the workbook and the entire scope of the review.
Step 4 — Review with the site owner
Add two columns to the filtered workbook: Decision and Owner note. Walk the site owner through the Unique rows and tag each one:
- Reset — the unique ACL matches the parent (noise from an accidental Share click) or the owner confirms the extra grant is stale.
- Remove user — a specific person shouldn't be on this scope. Common for ex-employees still listed on old folders.
- Keep — legitimate intentional deviation from the parent. Record the reason in Owner note; that's the audit answer next quarter.
Pivot the filtered rows by Principal first. Any principal that shows up on 50+ scopes is nearly always a former employee, decommissioned service account, or a finished vendor engagement — those clear in a singleRemove-PnPListItemPermission loop and shrink the workbook dramatically before the owner ever opens it.
Step 5 — Execute (SharePoint UI or PnP PowerShell)
Smart Permissions is read-only — the actual remediation runs in one of two places:
SharePoint UI (dozens of rows)
For each Reset row, open the item, Manage access → Advanced → Delete unique permissions. For each Remove user row, Manage access, click the user, Remove.
PnP PowerShell (hundreds+ rows)
Split the tagged workbook into two CSVs and run:
Import-Csv reset.csv | ForEach-Object { Set-PnPListItemPermission -List $_.List -Identity $_.ItemId -InheritPermissions }
Import-Csv remove.csv | ForEach-Object { Remove-PnPListItemPermission -List $_.List -Identity $_.ItemId -User $_.Principal }
Step 6 — Re-run and archive
Re-run the Smart Permissions report and export again. The Unique-row count should have dropped by 60–90%. Save both workbooks — pre-audit and post-audit — together with the owner's decision column intact. That paired export is the auditor-ready evidence pack.
Put the next re-run on the calendar. Quarterly for active sites, twice a year for archives.
What "auditor-ready" means in practice
- Every Unique scope on the site has a written decision against it.
- Every decision has a named owner.
- Every Reset and Remove action can be reproduced from the tagged CSV.
- A before / after report shows the drop in unique-permission scopes.
Related
- SharePoint Smart Permissions (the tool)
- How to audit SharePoint permissions (without losing a week)
- How to remove unique permissions in SharePoint Online
- The SharePoint permissions Excel export — how to turn it into decisions
- SharePoint permissions inheritance: complete reference
- SharePoint governance: complete reference
Permissions tools
- free SharePoint permission audit tool — free, read-only, MIT-licensed SPFx web part.
- SharePoint permissions reporting tool — what to look for when choosing one.
Get your first result in about 10 minutes
Visual permissions audit + Excel export. No PowerShell. Free, MIT licensed, no sign-up.
- Download the .sppkg package from the latest release.
- Upload it to your tenant App Catalog.
- Add the web part to a SharePoint page.
Email me when a new release ships
No marketing spam. One short email when a new release ships. You can unsubscribe anytime.
The SharePoint permissions guides
Understand how access is granted, report on who actually has it, then compare the tools that get you there.
Understand
How permission levels, groups, inheritance and sharing links actually fit together.
Where inheritance breaks, why it matters, and how to find every object with unique permissions.
Answer the question a manager asks most, down to a single folder or file.
Report
The free permissions report: every site, library, folder and file, exported to Excel.
What a permissions report should contain and how to run one without PowerShell.
A repeatable audit: scope, run, review, remediate, and re-check.
Find every guest with access before a Copilot rollout or a security review.
See the real people behind a group, not just the group name.
Was this page helpful?
One click. No form, no email address.
Missing something in SharePoint Smart Permissions? Feature requests and bug reports go straight to the developer on GitHub — no account needed to read, free account to post.
Request a featureRelated tool
SharePoint Smart Permissions
Visual permissions audit + Excel export. No PowerShell. Free, MIT licensed, no sign-up.
Keep reading
How to see every SharePoint site you have access to (and build a site directory)
SharePoint has no built-in page that lists every site a person can open. A PnP Modern Search results web part with a contentclass:STS_Site query gives you one — security-trimmed, self-updating, and free.
The SharePoint permissions Excel export — how to turn it into decisions
Exporting a SharePoint permissions report to Excel is easy. Turning 5,000 rows into decisions is the actual audit. Here's the review workflow.
How to remove unique permissions in SharePoint Online (audit + reset workflow)
Every Share click in SharePoint Online quietly creates a unique permission. Here's how to find them all in Excel, then reset the safe ones from the SharePoint UI or PowerShell.
Want a second set of eyes?
Get a SharePoint permissions audit from our team
We review who can see what across your sites, flag oversharing before you roll out Copilot, and help you put a cleanup plan and governance in place.
About the author
Sean Regan
SharePoint & Microsoft 365 consultant with 20+ years of hands-on experience building SPFx web parts, migration tooling and tenant-grade automation. Maintainer of the open-source SharePoint Smart Solutions suite.
