Wednesday, July 20, 2011

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.

1 comment:

  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

MYSQL:::Seamless Data Archiving: Exporting, Importing, and Pruning MySQL Tables

  Seamless Data Archiving: Exporting, Importing, and Pruning MySQL Tables Introduction: In the dynamic landscape of database management...