Security Stored Procedures (Transact-SQL)

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

sp_addapprole	sp_dropsrvrolemember
sp_addlinkedsrvlogin	sp_dropuser
sp_addlogin	sp_grantdbaccess
sp_addremotelogin	sp_grantlogin
sp_addrole	sp_helpdbfixedrole
sp_addrolemember	sp_helplinkedsrvlogin
sp_addserver	sp_helplogins
sp_addsrvrolemember	sp_helpntgroup
sp_adduser	sp_helpremotelogin
sp_approlepassword	sp_helprole
sp_changedbowner	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_droplinkedsrvlogin	sp_revokelogin
sp_droplogin	sp_setapprole
sp_dropremotelogin	sp_srvrolepermission (Transact-SQL)
sp_droprolemember	sp_validatelogins
sp_dropserver

See Also

Reference

System Stored Procedures (Transact-SQL)