Allow user Profiler rights without SYSADMIN

Microsoft were nice enough to give us a feature within SQL 2005 which would allow us to grant a user permission to do a SQL trace using Profiler, without having to give them SQL SYSADMIN access… which is GOD access… that’s a big no no.

For SQL 2005 / 2008 users use the below

SQL user Example:

GRANT ALTER TRACE TO [UserNameHere];

AD user Example:

GRANT ALTER TRACE TO [domain\Myaccount];

For the SQL 2000 users sorry you still have to use sysadmin access but I did come across a nifty trick that may do the job.

“write a batch file that calls Profiler from the command line as follows:

profiler /Sserver /Uuser /Ppassword /Tx

Then I bought a batch file compiler (do a google search and lots come
up, most around $30) and compiled the batchfile in to an executable.
Now I just distribute the executable.”

Read the article here

This entry was posted on Wednesday, September 2nd, 2009 at 10:51 am and is filed under Microsoft, SQL Server . You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “Allow user Profiler rights without SYSADMIN”

  • Brandan Hadlock Says:
    September 15th, 2009 at 3:55 am

    Brad,

    Our IT manager asked me to contact you to see if you’d be interested in doing some freelance work customizing one of your scripts. I could not see another way to contact you besides leaving a comment. Please contact me at 801-924-7737 or brandanhadlock@directcorp.com. Phone is preferrable so that I can more easily explain what we need done. Thanks.

Leave a Reply