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 |
|
tfountain
Constraint Violating Yak Guru
491 Posts |
 Posted - 2009-07-02 : 15:19:19
|
| My basic need is to identify all server wide permissions that have been granted. The intent is to revoke those permissions dynamically. What is the best programmatic approach? I am thinking about querying the sys.server_permissions table and filtering for class_desc = 'SERVER', state_desc = 'GRANT'.Just as an FYI, this is only one portion of a larger scoped task so I'm not just going blindly remove all server permissions. The required permissions for a given account will be added back to the system as a later step of this script. |
|
|
|
|
|
Question on determining server wide permissions...