Skip to main content Skip to Ask Learn chat experience

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Download Microsoft Edge More info about Internet Explorer and Microsoft Edge
Read in English

Note

Access to this page requires authorization. You can try signing in or changing directories.

Access to this page requires authorization. You can try changing directories.

In this article

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)


Additional resources


  • Last updated on 2010-10-01

In this article

en-us
Your Privacy Choices
  • AI Disclaimer
  • Previous Versions
  • Blog
  • Contribute
  • Privacy
  • Consumer Health Privacy
  • Terms of Use
  • Trademarks
  • © Microsoft 2026