Proper Roles for Server Tracing Purpose
-
Hi All,
I need to grant proper roles to an existing non-admin SQL Server user or create a new one for SQL Server tracing purpose. It seems that the fixed system administrators role is not a proper role for a non-admin user because it is too powerful. It will be nice if minimum rights can be granted to enable this user to perform tracing. I would be appreciated any advice and suggestions on this.
Thanks in advance!
Yichang
-
Books Online:
"With Windows Authentication mode, the user account that runs SQL Profiler must be granted permission to connect to an instance of SQL Server. The login account also must be granted permissions to execute SQL Profiler stored procedures"
SQL Profiler Procedures sp_trace_create sp_trace_setfilter sp_trace_generateevent sp_trace_setstatus sp_trace_setevent 
-
Andrew,
this is an error in Books Online. Users must be a member of the sysadmin role under SQL Server 2000 in order to execute traces.
The text you've cited has been edited in the most recent Books Online. It ends after: "With Windows Authentication mode, the user account that runs SQL Profiler must be granted permission to connect to an instance of SQL Server."
Updated Books Online (Jan 2004)
K. Brian Kelley
@kbriankelley
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply