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)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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_addlinkedsrvloginsp_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_writesp_helprole
sp_changedbownersp_helprolemember
sp_changeobjectowner (Deprecated)sp_helprotect (Deprecated)
sp_change_users_loginsp_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_encryptionsp_password (Deprecated)
sp_dropalias (Deprecated)sp_remoteoption (Deprecated)
sp_dropapprole (Deprecated)sp_revokedbaccess (Deprecated)
sp_droplinkedsrvloginsp_revokelogin (Deprecated)
sp_droplogin (Deprecated)sp_setapprole
sp_dropremotelogin (Deprecated)sp_srvrolepermission (Deprecated)
sp_droprole (Deprecated)sp_validatelogins
sp_droprolemember (Deprecated)

System Stored Procedures (Transact-SQL)
Security Functions (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft