Permission required to run the Profiler and the Debugger

8 Mar 2007 11:59 PM

Cordelia

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

9 Mar 2007 1:25 AM

Hari Prasad

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

Show quote

"Cordelia" <Corde***@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

14 Mar 2007 6:23 PM

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

Show quote

"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" <Corde***@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
>
>
>