Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


Managing SharePoint Access Requests

By:   |   Last Updated: 2010-02-18   |   Comments   |   Related Tips: > Sharepoint


As SharePoint system administrator, I create all sites for users. This is true even when I turn over "Full Control" to a power user that will design and maintain the site, including setting up permissions. However, I still get the automated email messages from users that "request access" using the built-in access request form. Is there a way I can direct these email messages to go the power user in charge of the site?


Yes. In WSS2, the configuration was easily found in "Site Administration". It was called "Manage Access Requests".

In WSS3/MOSS2007, the configuration is the same, but the menu option is in a more obscure location. Follow the directions below to modify the requests.

Click "Site Actions", then "Site Settings".

Click "Advanced permissions".

Click "Access Requests".

Allowing user requests (through the automated form), is optional. Change the email address to the desired site administrator.


  • This configuration is for the entire site. There are no settings for individual libraries and lists. Access requests for all lists or libraries all go to the same person.
  • The automated email sent to the site administrator contains a convenient link to 'grant' access to the resource (list or library). If you are using groups to manage permissions, you should not use the 'grant' link to manage the permission, though it can be helpful to see which resource the user is requesting access to. Consider, disabling automated access requests entirely, in favor of forcing the user to make a specific request (outside of the automated system). At the very least, be mindful that the automated request system is not aware of your grouping setup.
Next Steps
  • Check out MSSQLTips.com for great information about Microsoft SQL Server.

Last Updated: 2010-02-18

get scripts

next tip button

About the author
MSSQLTips author Rob Fisch Rob Fisch has worked with SQL Server since version 6.5 as a dba, developer, report writer and data warehouse designer.

View all my tips

Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 

Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.


Learn more about SQL Server tools