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
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.
October 7th, 2020 at 9:44 pm
Twitter Proxies…
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…