Allowing Users to Execute Traces in SQL Server

In this video Brian takes you through adding the permissions to non-sysadmin users to be able to execute traces on a SQL Server instance by using GRANT ALTER TRACE. He also goes over some of the limitations and security features of SQL Profiler when running traces.

Brian is a SQL Server author, columnist, and MVP focusing primarily on SQL Server security. He currently serves as database administrator / architect at AgFirst Farm Credit Bank where he can focus on his passion: SQL Server. He formerly served as a systems and security architect for AgFirst Farm Credit Bank where he worked on Active Directory, Windows security, VMware, and Citrix. In the technical...

luther smith on 1/28/2009

Crisp and clear.

Venkata Taduri on 2/24/2009

Pretty clear.

Anatoly Goldstein on 4/9/2009

This video can be considered as a great answer to my comment on another video. Thanks a lot!

SAy Soukamneuth on 5/11/2009

good

Carsten Hynne on 8/14/2009

I believe the comment about being able to see returned data like social security numbers is wrong. I don't think SQL Profiler ever shows the returned data. We only see it in your example because the data is in the query itself. Apart from this, I think it's a really good demonstration. Thanks.

Venkatesan on 8/14/2009

good

Team FAB on 8/14/2009

Might have been nice to just show it turned off again as well.

Raghu on 8/14/2009

nice presentation

Joe Pattison on 8/14/2009

Thanks for the information. It is good to know that it is available, and the risk for making it available.

Martin Miller on 8/14/2009

Good info to know. I aprreciated the perspective given with comparison of 2000 and 2005.

phani on 8/14/2009

Excellent Info

frank on 8/14/2009

short but direct to the point. Excellent

nilanaksha on 8/16/2009

Good. Hope to get some more of profiler topics like to identify blocking with traces, etc.

Don on 8/17/2009

I liked the explanation regarding security. The fact that sensitive data could be seen in clear text is not something that I would necessarily think of when a developer is asking for the ability to run a trace.

Kenneth Olson on 8/19/2009

Excellent timing on this subject. I had a need yesterday.

sreekanth on 8/19/2009

gr8

Anand on 8/19/2009

good

Kiran on 9/11/2009

its informative..thank you

Tonci on 9/21/2009

Simple and to the point. Thank you.

lakshmi on 11/4/2009

its good

Ranjith on 2/13/2010

Excellent