Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to Grant ALTER TRACE permission using Management Studio? Expand / Collapse
Author
Message
Posted Thursday, April 05, 2007 11:29 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, March 27, 2014 8:05 AM
Points: 454, Visits: 853

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




Post #356359
Posted Thursday, April 05, 2007 11:38 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 31, 2014 3:12 PM
Points: 134, Visits: 319

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




Post #356363
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse