Category Archives: Permissions

User and User Group Queries

I get user requests all the time for access rights and i don’t have read access to AD to check groups to see if the user is already a member or not. We can run the below scripts from SQL server Management … Continue reading

Posted in MSSQL, Permissions | Leave a comment

Providing Permissions for Non-Admin users to use Activity Monitor

Windows 2012 and SQL 2012 To grant permission for Non-Admin users to use Activity Monitor on an SQL 2012 server, follow the below 1) Add [Domain\Username] to [Computer Management] –> [Performance Monitor Users] 2) Run the below script on SQL Instance … Continue reading

Posted in MSSQL, Permissions | Leave a comment