Smart Solutions
Need help?
  • 100% Free & MIT Licensed
  • No third-party data hosting
SharePoint PermissionsAuditGovernance

How to run a full SharePoint permissions audit with Smart Permissions (free)

9 min readBy Offered as a service by our team

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

Permissions tools

Free · MIT license · no sign-up

Get your first result in about 10 minutes

Visual permissions audit + Excel export. No PowerShell. Free, MIT licensed, no sign-up.

  1. Download the .sppkg package from the latest release.
  2. Upload it to your tenant App Catalog.
  3. Add the web part to a SharePoint page.
Install guide
Download the latest releaseView on GitHub
Email me when a new release ships
Get notified when SharePoint Smart Permissions updates

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.

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 feature

Related tool

SharePoint Smart Permissions

Visual permissions audit + Excel export. No PowerShell. Free, MIT licensed, no sign-up.

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.