AB-900 Step by step · Lab 13

Fix SharePoint Oversharing Before Copilot Finds It

Find overshared sites, ask owners to review access, hide sites from Copilot and lock the sensitive ones with SharePoint Advanced Management.

· 5 min read

SharePoint data access governance report listing sites with the number of people who have access
Watch the lesson: Lab 13: Oversharing and SharePoint Advanced Management | AB-900 Copilot Step By Step

Copilot never breaks permissions. But it finds everything a person can already open, in seconds. If a site is shared too widely, Copilot makes that visible the first time someone asks the right question. So the fix is not in Copilot. It is in SharePoint.

This is the clean-up we do at Pragati Industries in Lab 13 of the AB-900 course.

Four tools, in order

  1. Find the overshared sites: data access governance reports.
  2. Fix them: a site access review asks the owners to clean up.
  3. Hide a site while they do: restricted content discovery keeps it out of Copilot and search.
  4. Lock the most sensitive sites: restricted site access lets only chosen groups in.

All four come with SharePoint Advanced Management, which is included with Copilot licences.

Step 1: Find the overshared sites

In the SharePoint admin center → Advanced management, the content management assessment lists the sites that need attention for oversharing, each with recommendations.

SharePoint content management assessment: 15 sites require attention for oversharing
The assessment: sites that need attention, with the issue type and recommendations.

Then Reports → Data access governance → Site permissions across the organization → View report. For each site: how many people have access, guests, groups, anyone links, and permissions for everyone except external users.

Site permissions report: sites with the number of unique users and permission counts
The site permissions report: the evidence you need before deciding anything.

Step 2: Let the owners decide

The admin should not judge every site alone. Select Sales and Marketing, open to 17 people, and Initiate site access review. Its owners check who has access and remove who should not. Add a comment for them, and Send; the review status shows in the report.

Initiate site access review panel for the Sales and Marketing site, with a comment for site owners
A site access review: the people who know the content clean up its access.

Step 3: Hide a site from Copilot while they work

Active sites → Finance Budgets → Settings → Restrict content discovery: On. The site still works for its members, but its files no longer appear in Copilot answers or organisation-wide search for people who never worked there.

Finance-Budgets site settings with Restrict content discovery set to On
Restricted content discovery: one site, and members can still open it. Large sites take a while to update the index.

Step 4: Lock the most sensitive site

The HR site needs more than hiding. HR Confidential → Settings → Restricted site access → Edit, and restrict access to users in specified groups. The site’s own group is in by default, and that is all HR needs.

Restricted site access: only users in the HR-Confidential group may access the site
Restricted site access: only chosen groups get in, sharing links or not.

How you know it worked

Joni, who was given read access in an earlier lab, is not in the HR group. After Save, she, and Copilot on her behalf, lose access to the site, even with a sharing link. Copilot answers as the user: whatever blocks the user, blocks Copilot.

Which one when

  • Restricted content discovery: one site, members can still open it, Copilot and search for everyone else cannot.
  • Restricted site access: one site, only chosen groups get in at all.
  • Restricted SharePoint Search: the whole tenant; Copilot and search see only an allowed list of up to a hundred sites. A temporary measure, set in PowerShell.

What a tech lead should take away

  • Run the reports before the licences go out. Oversharing is cheaper to fix before Copilot finds it.
  • Owners review, admins enable. Site access reviews scale; one admin judging every site does not.
  • Keep it fixed: site lifecycle policies, owner attestation every six months and change history stop old, ownerless sites from becoming the next problem.

Do it yourself

Lab guides, practice and full mock exams come with a subscription. See the plans