Episode Details

Your SharePoint permissions are probably a mess—not because you don’t manage them, but because nobody can keep up with thousands of sites changing daily. In this episode, I show you how to move from one‑off, spreadsheet‑driven reviews to an automated, tenant‑wide auditing approach that actually keeps up with reality. We start from the real pain of traditional reviews: endless exports, missed nested groups, and “final” reports that are already outdated by the time the meeting starts.

From there, we dig into why manual permission reviews break at enterprise scale and treat permissions as living data, not a static list. You’ll hear how inheritance, group nesting, and constant content churn make eyeballing site members useless beyond a small intranet scenario. We talk through real incidents where guests and ex‑employees still had edit access—despite “complete” audits—because their permissions were buried in group hierarchies no human could reliably track.

Then we build the technical foundation for real automation with PnP PowerShell. You’ll learn how to connect to every site in your tenant without opening a single browser tab, why app‑only, certificate‑based authentication is essential for unattended jobs, and how to enumerate sites in a way that respects throttling and actually finishes on schedule. Instead of brittle, one‑off scripts, you get a repeatable pattern that plugs directly into your admin center and Graph.

Finally, we add Microsoft Graph API to mine the permission data that actually matters. We walk through how to pull site, library, folder, and file‑level permissions; resolve nested Azure AD groups into real users; and consolidate everything into a single dataset you can slice by user, site, or sensitivity. By the end, you’ll see how to turn weeks of manual review into automated reports that can run daily—and how that changes your conversations with security, compliance, and auditors.

WHAT YOU LEARN

• Why traditional, spreadsheet‑based permission reviews collapse once you have thousands of sites and constant change.
• How hidden inheritance and nested groups create blind spots that humans rarely catch in manual audits.
• How to use PnP PowerShell with app‑only authentication to connect to every SharePoint site automatically.
• How Microsoft Graph API exposes site, library, and item‑level permissions so you can see real effective access.
• How to combine both tools into an automated reporting pipeline that delivers accurate, repeatable permission snapshots.

CORE INSIGHT

The core insight of this episode is that SharePoint Online permission auditing only becomes trustworthy when you stop treating it as a yearly snapshot and start treating it as a continuous, automated data problem. When PnP PowerShell handles discovery, Microsoft Graph surfaces the full permission graph, and your reports update on a schedule, you trade luck and heroics for a system that actually shows who has access to what—before your next incident or audit does.

Listen Now