To run Microsoft's tenant-wide permission reports, you sign in as a SharePoint administrator, a role that can give itself access to any site or OneDrive in your tenant. So the person checking who has too much access ends up with more access than almost anyone in the tenant. A SharePoint permissions audit doesn't have to work that way.
The fix is to separate seeing permissions from changing them. Run the tenant-wide snapshot once under a tightly controlled admin account, send site-level findings to the owners who can act on them, and give auditors scoped, read-only views of the part of the tenant they're responsible for. Orchestry's Enterprise roles and attribute-based access let a regional or departmental auditor see the workspaces they're responsible for without handing them the SharePoint admin role.
Microsoft's tenant-wide view of SharePoint permissions lives in the data access governance reports. They include a site permissions report across every SharePoint and OneDrive site, a report of every site a specific user can reach, and activity reports for sharing links and "Everyone except external users" grants. To open them, you sign in to the SharePoint admin center with SharePoint administrator credentials, and the full set needs SharePoint Advanced Management.
SharePoint admin center data access governance reports used for a tenant-wide SharePoint permissions audit
Tenants on Microsoft 365 E5 without SharePoint Advanced Management get a thinner version: activity reports only, capped at 10,000 sites, with no snapshot reports and no remediation actions. Tenants with a Copilot license already have SharePoint Advanced Management included.
The role is the problem. Microsoft's description of the SharePoint Administrator role says these admins don't automatically have access to every site and OneDrive, but they can give themselves access to any of them. They can also change sharing settings and group owners across the tenant. Microsoft recommends using roles with the fewest permissions, but it doesn't document a lower-privilege role that runs these reports.
The newer item-level reports go the other way: they need the SharePoint Advanced Management Administrator role, which adds viewing file names and paths across every site to everything a SharePoint admin can do
The alternatives don't help much:
Before deciding who runs the audit, be clear about what it has to find. SharePoint permissions accumulate in layers, which is why they get messy in the first place. A complete audit checks five things:
The last item is the reason least privilege matters for the audit itself.
You can audit SharePoint permissions across the tenant without giving every auditor a tenant-wide admin role. These six steps work with native tools, and a governance platform makes steps 3 to 5 easier to run at scale:
Orchestry Access Control roles page with separate admin roles for workspaces, OneDrive, guests, templates and licensing
Orchestry is built for steps 3 to 5 at scale. On Enterprise, admin access splits into separate roles, such as Workspaces Admin, OneDrive Admin, Guests Admin, Templates Admin and Licenses Admin, so the person reviewing workspace permissions doesn't also manage licenses or guests. A history tab records role changes over time for your own audit trail.
Orchestry attribute-based access segments that limit workspace reporting to North America, EMEA and APAC audiences
Attribute-based access narrows the view further. You define segments from workspace metadata, such as location or department, and people in each segment see only the matching workspaces in Orchestry's workspace reporting and dashboards. A compliance lead for EMEA sees EMEA workspaces and nothing else.
Inside those views, Orchestry's permissions reporting shows each workspace's permissioned users, Entra groups, "Everyone except external users" grants, sharing links and broken inheritance on folders and files, and the Sharing Overview report ranks workspaces by sharing risk. Workspace reviews then send the fixes to owners on a schedule.
Each way of producing a SharePoint permissions report needs a different level of access. Here's what each one shows and what it costs you in privilege:
| Method | What it shows | Role it needs | Watch out for |
|---|---|---|---|
| Data access governance reports | Site permissions across the tenant, sites a user can reach, recent sharing links and "Everyone except external users" grants | SharePoint admin, with SharePoint Advanced Management for the full set | The role can give itself access to any site |
| Site permissions page | Permissions on one site | Site owner or site admin | One site at a time; no tenant view |
| PowerShell or Graph scripts | Whatever the script enumerates, down to items | App registration with tenant-wide site access | Scripts and app secrets need ongoing maintenance |
| Site access review | Owner-confirmed fixes on overshared sites | SharePoint admin starts it; owners complete it | SharePoint sites only, no OneDrive |
| Orchestry | Workspace permissions, sharing links, inheritance and sharing risk, scoped by role and attribute | Orchestry role (Enterprise for scoped roles) | Attribute segments use managed metadata, so workspaces need tags |
No. Site owners and site admins can manage permissions on the sites they own, but they don't have access to the SharePoint admin center, so they can't see permissions across other sites.
You sign in to the SharePoint admin center as a SharePoint administrator and the full set of reports needs SharePoint Advanced Management. The item-level reports for "Everyone" and "Everyone except external users" need the SharePoint Advanced Management Administrator role, which a Global Administrator assigns. Tenants on E5 without SharePoint Advanced Management get activity reports for up to 10,000 sites, but no snapshot reports.
Run the site permissions for users report in the data access governance reports. It lists every site the user can access and whether that access comes directly or through a group.
Microsoft suggests snapshot reports quarterly and activity reports monthly. Owner reviews in between catch new sharing links and grants before they pile up.
No, it finds it. Fixing oversharing takes owner reviews, link cleanup and permission changes after the audit, which is why the audit should feed straight into site access reviews or scheduled workspace reviews.
If you're planning a SharePoint permissions audit, see how Orchestry gives auditors scoped views without handing them the SharePoint admin role. Book a 30-minute walkthrough in your own tenant.