SQL Server Trace (aka SQL Profiler) Priveliges without giving sysadmin

Posted by Chris Straw on April 7, 2012 in SQL Server |

I’m a big proponet of using SQL Server Profiler for monitoring DB activity from applications. When a client has a SQL Server DBA on staff, they continuously tell me they can’t grant me Trace privileges without giving me sysadmin privileges. Oh yes they can! Below is the simple script to grant a particular user trace privileges without granting sysadmin (god access).

GRANT ALTER TRACE TO [useridhere];


Leave a Reply

Your email address will not be published. Required fields are marked *

Copyright © 2011-2019 Chris Straw All rights reserved.
This site is using the Desk Mess Mirrored theme, v2.5, from BuyNowShop.com.