Wednesday, March 7, 2012

Permission required to run the Profiler and the Debugger

Does anyone know what permission to grant (other than SA) in order to enable
the usage of SQL Profiler 2005 and the debugger on a 2005 installation?
thanks
Cordelia
Give the permission ALTER TRACE to execute profiler.
Debugging can be done trhu only the visual studio.
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124550
Thanks
Hari
"Cordelia" <Cordelia@.discussions.microsoft.com> wrote in message
news:57E838C3-F49D-4283-BF8F-D37701E195CA@.microsoft.com...
> Does anyone know what permission to grant (other than SA) in order to
> enable
> the usage of SQL Profiler 2005 and the debugger on a 2005 installation?
> thanks
> Cordelia
|||Thanks Hari for the info. Granting ALTER TRACE seems to have done the trick
for runing the Profiler. According to the BOL, ALTER TRACE enable the
account to replay a trace file. Any idea what else does ALTER TRACE provide
permission for?
As for the debugger, does an account require any permission setup to be able
to debug via Visual Studio?
Cordelia
"Hari Prasad" wrote:

>
> Give the permission ALTER TRACE to execute profiler.
> Debugging can be done trhu only the visual studio.
> http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124550
>
> Thanks
> Hari
> "Cordelia" <Cordelia@.discussions.microsoft.com> wrote in message
> news:57E838C3-F49D-4283-BF8F-D37701E195CA@.microsoft.com...
>
>

No comments:

Post a Comment