Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DBADave
Constraint Violating Yak Guru
366 Posts |
 Posted - 2007-04-05 : 13:35:50
|
| How do you view permissions granted to an id, such as ALTER TRACE permission, using Management Studio? I want to see if ALTER TRACE permission has been granted to an id, but am unable to find this information in the GUI.Thanks, Dave |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-05 : 13:49:21
|
| I'm not sure where it is in the GUI, but you should be able to see this with sp_helpuser.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
DBADave
Constraint Violating Yak Guru
366 Posts |
Posted - 2007-04-05 : 14:27:29
|
| 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 listThanks, Dave |
|
|
|
|
|
|
How to view permissions using Management Studio?