Security Stored Procedures (Transact-SQL)
TOC
Collapse the table of content
Expand the table of content

Security Stored Procedures (Transact-SQL)

 

Published: January 6, 2016

Applies To: Azure SQL Database, SQL Server (starting with 2008)

SQL Server supports the following system stored procedures that are used to manage security. Some of these stored procedures are deprecated but continue to be available to support backward compatibility. The topics for deprecated procedures will list their replacement.

sp_addapprole (Deprecated)

sp_dropserver

sp_addlinkedsrvlogin

sp_dropsrvrolemember (Deprecated)

sp_addlogin (Deprecated)

sp_dropuser (Deprecated)

sp_addremotelogin (Deprecated)

sp_grantdbaccess (Deprecated)

sp_addrole (Deprecated)

sp_grantlogin (Deprecated)

sp_addrolemember (Deprecated)

sp_helpdbfixedrole

sp_addserver (Deprecated)

sp_helplinkedsrvlogin

sp_addsrvrolemember (Deprecated)

sp_helplogins

sp_adduser (Deprecated)

sp_helpntgroup

sp_approlepassword (Deprecated)

sp_helpremotelogin (Deprecated)

sp_audit_write

sp_helprole

sp_changedbowner

sp_helprolemember

sp_changeobjectowner (Deprecated)

sp_helprotect (Deprecated)

sp_change_users_login

sp_helpsrvrole

sp_dbfixedrolepermission (Deprecated)

sp_helpsrvrolemember

sp_defaultdb (Deprecated)

sp_helpuser (Deprecated)

sp_defaultlanguage (Deprecated)

sp_migrate_user_to_contained

sp_denylogin (Deprecated)

sp_MShasdbaccess

sp_describe_parameter_encryption 

sp_password (Deprecated)

sp_dropalias (Deprecated)

sp_remoteoption (Deprecated)

sp_dropapprole (Deprecated)

sp_revokedbaccess (Deprecated)

sp_droplinkedsrvlogin

sp_revokelogin (Deprecated)

sp_droplogin (Deprecated)

sp_setapprole

sp_dropremotelogin (Deprecated)

sp_srvrolepermission (Deprecated)

sp_droprole (Deprecated)

sp_validatelogins

sp_droprolemember (Deprecated)

Community Additions

ADD
Show:
© 2016 Microsoft