Hi Freinds,
SQL 2005 SP2
How can I grant only trace permission for a user? He needs to be able
to run profiler. I can't find Trace Role.
I read that SQL 2005 has a new role for granting trace and profiler
access without being a sysadmin.
Thanks in advance,
Pat
Ben Nevarez - 20 Mar 2008 18:52 GMT
You need to grant the ALTER TRACE permission to the user.
Hope this helps,
Ben Nevarez
> Hi Freinds,
> SQL 2005 SP2
[quoted text clipped - 6 lines]
> Thanks in advance,
> Pat