Permissions for running Performance Tools

[SQLBill]

I have a user who needs to run performance tools (such as Profiler) against my MS SQL Server 2000 database. I don't want to assign the user administrative access and I don't want this user to be able to make changes to the database. Is there a way (such as a role) that I can enable this user to be able to run performance tools, without also giving administrative privileges out?

-Bill

 

[RickCole]

You can create a role and then give the role permissions to execute the required extended system stored procedures held in the master database.

Look in BOL under the topic "System Stored Procedures (T-SQL)" and then under the category "SQL Server Profiler Extended Procedures". These are the procedures your new role will need execute permission too.

Alternatively you could just give the required user permissions to these procedures.

Rick.