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

Reference

System Stored Procedures (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance