Learn more about SQL Server tools

mssqltips logo
 

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

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 
>>> >> > Make the most of SQL Server Integration Services Script Components < << <<<
 

'Watchout' for Access Requests When Managing Permissions With Groups


By:   |   Read Comments   |   Related Tips: > Sharepoint

Problem

When managing permissions with groups, the link in the automated access request email is wrong.

Solution

When users try to access a resource without the needed permissions, they get a web page with an error message. In the default configuration, the web page offers a "Request access" link.

When clicking the link, the user can send a brief message. The message is emailed to whoever is configured to manage access requests.

The Admin Notification

When the email arrives, it contains a link. This link is useful if you manage permissions on the resource by named user. HOWEVER, if you manage permissions by using SharePoint or Active Directory Groups, the link in the email is misleading and should not be used.

Before blindly clicking on the link, review the permissions setup to see if the resource is managed by 'named user' or by 'group'.

Next Steps


Last Update:


next webcast button


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