September 21, 2010 at 4:21 pm
Hello Everyone
I am searching the SQL BOL for the role that has permissions to run SQL Profiler, other than sysadmin of course.
Thanks
Andrew
September 21, 2010 at 5:55 pm
Hi Andrew,
I don't believe there is a specific role other than sysadmin. The individual permission is ALTER TRACE:
GRANT ALTER TRACE TO [Domain\Account]
Books Online: http://msdn.microsoft.com/en-us/library/ms187611(v=SQL.90).aspx
September 22, 2010 at 6:23 am
From Books Online:
Security
In Windows Authentication mode, the user account that runs SQL Server Profiler must have permission to connect to an instance of SQL Server.
To perform tracing with SQL Server Profiler, users must also have the ALTER TRACE permission.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply