Updated Permissions Spreadsheet for SharePoint 2010

Permissions within SharePoint provide a great way of controlling access to SharePoint sites and content. These permissions also allow for the User Interface to be trimmed so users only see the links and the content that they have access to.

Back in the days of SharePoint 2007 a colleague Mark Arend (http://blogs.msdn.com/b/markarend/) put out handy Spreadsheet detailing the various permissions as they were mapped against the out-of-the-box roles and groups. The Spreadsheet also provided the permissions required to view links within Central Admin.

With the introduction of SharePoint 2010 there are some additional links within the Site Settings that are subject to security trimming. I’ve updated Mark’s original Spreadsheet with these new permission settings. Click here to download the updated Spreadsheet with these new permissions.

rob finney

Rob Finney
Microsoft Consulting Services UK

Click here for my bio page

Comments (10)

  1. AllenWang says:

    Nice work, thanks mate!

  2. Paul van den Akker says:


    Thanx for the matrix, gives me a nice overview to explain it to our customers. Also saves me a lot of work 🙂

  3. Tina says:

    Nice job. Saves lot of explaination and time

  4. You guys are awesome. Thanks! says:

    I will continue to share it with my security standards and recommendations. 🙂

  5. Krishna Addepalli says:

    Thanks for sharing.  I will try to use it.

  6. Jens Hirschmann says:

    Thank you for sharing that. I'll try to use it wisely 🙂

  7. Scott Maser says:

    I was going through the matrix and compared it to an OOTB farm I have in my development lab.  I noticed the spreadsheet shows Design permissions can "Manage Alerts"; however, OOTB settings show that unchecked.

  8. I loved and used both Mark's original 2007 and your 2010 versions–especially by adding columns to document in-house custom permission levels.  I don't suppose you or someone might continue forward with a 2013 update?

  9. shaghaiegh says:

    Tanks a lot

  10. Coralie says:

    Yes please to a 2013 update. The new 'Edit' permission, applied by default to site members, was a bit of a surprise to us.

Skip to main content