Permissions needed to run SQL Profiler
-
Need to create a role on the db that will be granted to developers whenever they need to use SQL Profiler. I need the permissions that will aloow them to do witthout given them the SYSADMIN role. Any help is greatly appreciated.
-
In SQL Server 2000, you need sysadmin privilege to run profiler. The same is not the case with SQL 2005.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com -
Hi,
in 2005 you need to grant ALTER TRACE permissions:-
grant
alter trace to {your user here}
HTH
Paul
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply