How to give Site Collection Or Admin Permission on all Sites in SPO in one go

by

Managing SharePoint Online permissions efficiently is crucial for administrators, especially when handling multiple site collections. This blog post will guide you through using PowerShell to connect to SharePoint Online, retrieve all site collections, and assign a user as a Site Collection Administrator across all sites.

Prerequisites

Before running the script, ensure you have the following:

  • Installed SharePoint Online Management Shell
  • Appropriate SharePoint Online administrator permissions
  • Global Administrator or SharePoint Administrator role in Microsoft 365

Steps to Automate Admin Access

1. Connect to SharePoint Online

First, establish a connection to SharePoint Online using the Connect-SPOService cmdlet:

Connect-SPOService -Url https://contoso-admin.sharepoint.com

2. Retrieve All Site Collections

Once connected, fetch all site collections in the tenant using:

$siteCollections = Get-SPOSite -Limit All

This command retrieves all SharePoint Online site collections without limitation.

3. Grant Admin Access to a User

To add a user as a Site Collection Administrator for each site collection, use the following loop:

foreach ($siteCollection in $siteCollections) {
Set-SPOUser -Site $siteCollection.Url -LoginName “user@contoso.com” -IsSiteCollectionAdmin $true
}

Replace user@contoso.com with the appropriate user’s email address.

Explanation

  • Connect-SPOService establishes a session with SharePoint Online.
  • Get-SPOSite -Limit All retrieves all site collections.
  • Set-SPOUser assigns the specified user as an administrator for each site.

Best Practices

  • Run the script in Administrator mode to avoid permission issues.
  • Always verify site collections before making bulk changes.
  • Consider running the script during off-peak hours to minimize impact.

Conclusion

Using this PowerShell script, you can efficiently assign Site Collection Administrator rights across all SharePoint Online sites, ensuring smooth administration and governance. Automating administrative tasks like this saves time and reduces manual effort.

For more advanced SharePoint Online automation, explore PowerShell modules like PnP PowerShell, which offer additional flexibility and functionality.

!!! THANKS FOR READING !!!

Regards,
HARISH KUMAR

Knowledge is not a finite resource to hoard; it’s a boundless treasure that grows when shared

Leave a Comment