How to Grant ALTER TRACE permission using 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

  • 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 should appear in the effective permissions list

     

    -WM

    DBA

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply