United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2005

Product Documentation

SQL Server 2005 Documentation

SQL Server 2005 Books Online

SQL Server Language Reference

Transact-SQL Reference

System Stored Procedures (Transact-SQL)

Security Stored Procedures (Transact-SQL)

sp_addalias (Transact-SQL)

sp_addapprole (Transact-SQL)

sp_addgroup (Transact-SQL)

sp_addlogin (Transact-SQL)

sp_addremotelogin (Transact-SQL)

sp_addrole (Transact-SQL)

sp_addrolemember (Transact-SQL)

sp_addserver (Transact-SQL)

sp_addsrvrolemember (Transact-SQL)

sp_adduser (Transact-SQL)

sp_approlepassword (Transact-SQL)

sp_change_users_login (Transact-SQL)

sp_changedbowner (Transact-SQL)

sp_changegroup (Transact-SQL)

sp_changeobjectowner (Transact-SQL)

sp_control_dbmasterkey_password (Transact-SQL)

sp_dbfixedrolepermission (Transact-SQL)

sp_defaultdb (Transact-SQL)

sp_defaultlanguage (Transact-SQL)

sp_denylogin (Transact-SQL)

sp_dropalias (Transact-SQL)

sp_dropapprole (Transact-SQL)

sp_dropgroup (Transact-SQL)

sp_droplogin (Transact-SQL)

sp_dropremotelogin (Transact-SQL)

sp_droprole (Transact-SQL)

sp_droprolemember (Transact-SQL)

sp_dropserver (Transact-SQL)

sp_dropsrvrolemember (Transact-SQL)

sp_dropuser (Transact-SQL)

sp_grantdbaccess (Transact-SQL)

sp_grantlogin (Transact-SQL)

sp_helpdbfixedrole (Transact-SQL)

sp_helplinkedsrvlogin (Transact-SQL)

sp_helplogins (Transact-SQL)

sp_helpntgroup (Transact-SQL)

sp_helpremotelogin (Transact-SQL)

sp_helprole (Transact-SQL)

sp_helprolemember (Transact-SQL)

sp_helprotect (Transact-SQL)

sp_helpsrvrole (Transact-SQL)

sp_helpsrvrolemember (Transact-SQL)

sp_helpuser (Transact-SQL)

sp_MShasdbaccess (Transact-SQL)

sp_password (Transact-SQL)

sp_remoteoption (Transact-SQL)

sp_revokelogin (Transact-SQL)

sp_revokedbaccess (Transact-SQL)

sp_setapprole (Transact-SQL)

sp_srvrolepermission (Transact-SQL)

sp_unsetapprole (Transact-SQL)

sp_validatelogins (Transact-SQL)

sp_xp_cmdshell_proxy_account (Transact-SQL)

Minimize

3 out of 4 rated this helpful - Rate this topic

Security Stored Procedures (Transact-SQL)

SQL Server 2005

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

Reference

System Stored Procedures (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.

|

Site Feedback

© 2013 Microsoft. All rights reserved.