Nov
11
2011
Grant users trace rights to SQL 2005, SQL 2008
WOW, its been over a year since I posted anything last time… I am going to try and start investing some more time into my blog, so any readers that I still have I am sorry for the long gap – its been a busy period.
Anyways back to the help – lets start with a nice easy quick one. You might remember in SQL 2000 days to give some rights to trace you needed to give the user SYSADMIN rights, well gone are those days, while it still works lets face it, its not too secure is it!
— Use this for users that are AD based
Use Master
Go
GRANT ALTER TRACE TO [DOMAIN\USERNAME]
Go
— Use this for a SQL user
Use Master
Go
GRANT ALTER TRACE TO [SQLUSERNAME]
Go
Now that user will be able to start tracing databases using SSMS and not having to be a SysAdmin!