Provide a SQL Login ALTER TRACE permission

Spread the love

Provide a SQL Login 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

Spread the love
Author: OTi
Meet OTi, the brains behind the popular tech blog "" OTi is an accomplished author, tech enthusiast, and an expert in SQL Server. With over a decade of experience in the tech industry, he has become a trusted voice in the world of database management. OTi's passion for technology began at a young age, and he has been tinkering with computers ever since. He graduated with a degree in Computer Science and has since worked for some of the biggest tech companies in the world. His experience has given him a deep understanding of how technology works and how it can be used to improve our lives.

2 thoughts on “Provide a SQL Login ALTER TRACE permission

  1. 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

  2. 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. Required fields are marked *