Provide a SQL Login ‘profiler access’ by ‘ALTER TRACE permission’


One SQL login holder asked DBA team “Please provide me profiler access urgently“. Mentioned user using a SQL login and he wants to run profiler on a particular database of a production server. A screenshot also shared by that user.


As the user already has ‘SQL login’ and ‘DATABASE user’ we checked and assigned that user ‘db_owner’. Then provide ‘ALTER TRACE’ permission to the use.

Using TSQL

Using SSMS

Facebook Comments Box
Please like or share this post if you found it helpful, thank you.
Share on Facebook
0Tweet about this on Twitter
Share on LinkedIn
Email this to someone
Print this page


  • Hello! I could have sworn I’ve been to this website before but after checking through some of the post I realized it’s new to me.
    Anyhow, I’m definitely glad I found it and I’ll be bookmarking and checking back

  • Hi, i believe that i saw you visited my web site thus i got here to go back the prefer?.I’m attempting to
    to find issues to enhance my website!I suppose its
    good enough to use a few of your ideas!!

Leave a Reply

Your email address will not be published.