SQL Server Performance Forum – Threads Archive

How to Grant ALTER TRACE in Management Studio?

I want to grant "ALTER TRACE" permission to an id, but do not know how to do this using Management Studio. I know how to run a SQL command to do this, but was curious where this is done in the GUI. Thanks, Dave

Not sure you can do it with MS.
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Someone just pointed me in the right direction. Security tab –> Logins –> right click name to modify select properties –> securables tab –> Click add –> Select the server you want to add the permissions to. The permissions appear in the Effective Permissions list Thanks, Dave

Is there any specific reason using SSMS to grant the access?
or
Just curiosity… MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

May be for the ease of operation and usual practice. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Granting Trace access is log easier using the command than GUI <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> MohammedU. Moderator SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

I feel thats true until SQL 2000, but now with SSMS it is good to handle. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

I agree with SSMS is good but ALTER TRACE permissions are not regularly visible…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

My interest was primarily out of curiosity. Thanks

[<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] I have guessed so. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of knowledge sharing. <hr noshade size="1">The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.</center>

]]>