Security Stored Procedures (Transact-SQL)

Microsoft SQL Server 2005 supports the following system stored procedures that are used to manage security.

sp_addalias	sp_droprolemember
sp_addapprole	sp_dropserver
sp_addgroup	sp_dropsrvrolemember
sp_addlinkedsrvlogin	sp_dropuser
sp_addlogin	sp_grantdbaccess
sp_addremotelogin	sp_grantlogin
sp_addrole	sp_helpdbfixedrole
sp_addrolemember	sp_helpgroup
sp_addserver	sp_helplinkedsrvlogin
sp_addsrvrolemember	sp_helplogins
sp_adduser	sp_helpntgroup
sp_approlepassword	sp_helpremotelogin
sp_changedbowner	sp_helprole
sp_changegroup	sp_helprolemember
sp_changeobjectowner	sp_helprotect
sp_change_users_login	sp_helpsrvrole
sp_dbfixedrolepermission	sp_helpsrvrolemember
sp_defaultdb	sp_helpuser
sp_defaultlanguage	sp_MShasdbaccess
sp_denylogin	sp_password
sp_dropalias	sp_remoteoption
sp_dropapprole	sp_revokedbaccess
sp_dropgroup	sp_revokelogin
sp_droplinkedsrvlogin	sp_setapprole
sp_droplogin	sp_srvrolepermission (Transact-SQL)
sp_dropremotelogin	sp_validatelogins

See Also