Give Access to check Activity monitor and to run SQL Profiler for non sysadmin login.

Scenario:
Need to get permission on the server that will enable to see the activity monitor and to work with the SQL Server Profiler on sql server.

Those permission are needed for testing the work done on the Test DB
--------------------------------------------------------------------------------------------
How to give access to check Activity monitor?

USE master;
GRANT VIEW SERVER STATE TO [windowslogin]

How to give access to run Sql Profiler on the server to one windows login i.e. non sysadmin?

USE master;
GRANT ALTER TRACE TO [windowslogin]

Or

Security tab --> Logins --> right click name to modify select properties --> Securables tab --> Click add --> Select the server you want to add the permissions to. The permissions should appear in the effective permissions list

You need to check the Grant column for the required permissions.

Comments

  1. Just want to say your article is as astounding.

    The clarity in your submit is just spectacular and that i can think
    you're knowledgeable in this subject. Well along with your permission let me to grab your RSS feed to stay updated with drawing close post.

    Thanks 1,000,000 and please continue the rewarding work.


    Review my web-site ... weight loss programs (http://www.cosmopolitan.com/)

    ReplyDelete

Post a Comment

Popular posts from this blog

SSIS2008R2 Error: 0xC0209303 at Package:

SQL2008R2 Error: The remote copy of database "XXXXX" has not been rolled forward to a point in time that is encompassed in the local copy of the database log. (Microsoft SQL Server, Error: 1412)