SQL 2005: Tracing… Not just for DBAs anymore

Posted by jeff.story
February 19, 2008

There has always been a gray fuzzy line on how much access does a DBA give to a developer working on a production database.   Too little access and they developer can’t do their job without involving the DBA and too much access has it’s own set of problems and is just not a good security practice.

It is common practice for developers to want to trace a SQL process to troubleshoot a problem or error.   In SQL 2000 you had a choice to either involve the SQL administrator each time you needed to run a trace, or have system administrator rights on the SQL server and do it your self.  SQL 2005 changes this with its server level permissions.  Using the following SQL command you can grant tracing permission to a SQL user. 

GRANT ALTER TRACE TO username
 
Keep in mind this is a server level permission and the user will be able to do traces on all databases on the server instance.   For more information check out SQL Server 2005 Books Online topic, GRANT Server Permissions.
 
StumbleUpon It!
Windows Administration

If you found this page useful, consider linking to it.
Simply copy and paste the code below into your web site (Ctrl+C to copy)
It will look like this: SQL 2005: Tracing… Not just for DBAs anymore


Enjoy this post? Please consider leaving a comment or subscribe to the feed and get future articles delivered to your feed reader.

Comments

No comments yet.

Leave a comment

(required)

(required)