Under SSMS I see the "securityadmin" Server role. Where in SSMS can I find the actual list of permsisions granted to this role? (not just a generic description of what this role can do.)
TIA,
Barkingdog
In summary they can add members to the securityadmin role, Grant or deny CREATE DATABASE and read the error logs. Additionally they are allowed to use the tasks:
sp_addlinkedsrvlogin,sp_addlogin,sp_defaultdb,sp_defaultlanguage,sp_denylogin,sp_droplinkedsrvlogin,sp_droplogin,sp_grantlogin,sp_helplogins,sp_remoteoption and sp_revokelogin.
The above mentioned list is from an old SQL 2000 scripts of mine. Additionally the description of the BOL and the appropiate command which are new for the above mentioned procedures apply.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment