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

Scenario

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.

Solution

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
Facebook
0Tweet about this on Twitter
Twitter
Share on LinkedIn
Linkedin
Email this to someone
email
Print this page
Print

Comments

  • 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
    frequently!

  • 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 *