| description | Security Stored Procedures (Transact-SQL) | |||
|---|---|---|---|---|
| title | Security Stored Procedures (Transact-SQL) | Microsoft Docs | |||
| ms.custom |
|
|||
| ms.date | 05/24/2022 | |||
| ms.prod | sql | |||
| ms.prod_service | database-engine, sql-database | |||
| ms.reviewer | ||||
| ms.technology | system-objects | |||
| ms.topic | reference | |||
| dev_langs |
|
|||
| helpviewer_keywords |
|
|||
| ms.assetid | 62b72907-7e95-4c97-9891-0c45d5b678ce | |||
| author | VanMSFT | |||
| ms.author | vanto | |||
| monikerRange | =azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDE SQL Server SQL Database]
[!INCLUDEssNoVersion] 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.
:::row::: :::column::: sys.sp_add_trusted_assembly :::column-end::: :::column::: sp_addapprole (Deprecated) :::column-end::: :::row-end::: :::row::: :::column::: sp_addlinkedserver :::column-end::: :::column::: sp_addlinkedsrvlogin :::column-end::: :::row-end::: :::row::: :::column::: sp_addlogin (Deprecated) :::column-end::: :::column::: sp_addremotelogin (Deprecated) :::column-end::: :::row-end::: :::row::: :::column::: sp_addrole (Deprecated) :::column-end::: :::column::: sp_addrolemember (Deprecated) :::column-end::: :::row-end::: :::row::: :::column::: sp_addserver (Deprecated) :::column-end::: :::column::: sp_addsrvrolemember (Deprecated) :::column-end::: :::row-end::: :::row::: :::column::: sp_adduser (Deprecated) :::column-end::: :::column::: sp_approlepassword (Deprecated) :::column-end::: :::row-end::: :::row::: :::column::: sp_audit_write :::column-end::: :::column::: sp_change_users_login (Deprecated) :::column-end::: :::row-end::: :::row::: :::column::: sp_changedbowner (Deprecated) :::column-end::: :::column::: :::column-end::: :::row-end::: :::row::: :::column::: sp_changeobjectowner (Deprecated) :::column-end::: :::column::: sp_control_dbmasterkey_password :::column-end::: :::row-end::: :::row::: :::column::: sp_copy_data_in_batches :::column-end::: :::column::: sp_dbfixedrolepermission (Deprecated) :::column-end::: :::row-end::: :::row::: :::column::: sp_defaultdb (Deprecated) :::column-end::: :::column::: sp_defaultlanguage (Deprecated) :::column-end::: :::row-end::: :::row::: :::column::: sp_denylogin (Deprecated) :::column-end::: :::column::: sp_describe_parameter_encryption :::column-end::: :::row-end::: :::row::: :::column::: sp_dropalias (Deprecated) :::column-end::: :::column::: sys.sp_drop_trusted_assembly :::column-end::: :::row-end::: :::row::: :::column::: sp_dropapprole (Deprecated) :::column-end::: :::column::: sp_droplinkedsrvlogin :::column-end::: :::row-end::: :::row::: :::column::: sp_droplogin (Deprecated) :::column-end::: :::column::: sp_dropremotelogin (Deprecated) :::column-end::: :::row-end::: :::row::: :::column::: sp_droprole (Deprecated) :::column-end::: :::column::: sp_droprolemember (Deprecated) :::column-end::: :::row-end::: :::row::: :::column::: sp_dropserver :::column-end::: :::column::: sp_dropsrvrolemember (Deprecated) :::column-end::: :::row-end::: :::row::: :::column::: sp_dropuser (Deprecated) :::column-end::: :::column::: sp_generate_database_ledger_digest :::column-end::: :::row-end::: :::row::: :::column::: sp_grantdbaccess (Deprecated) :::column-end::: :::column::: sp_grantlogin (Deprecated) :::column-end::: :::row-end::: :::row::: :::column::: sp_helpdbfixedrole :::column-end::: :::column::: sp_helplinkedsrvlogin :::column-end::: :::row-end::: :::row::: :::column::: sp_helplogins :::column-end::: :::column::: sp_helpntgroup :::column-end::: :::row-end::: :::row::: :::column::: sp_helpremotelogin (Deprecated) :::column-end::: :::column::: sp_helprole :::column-end::: :::row-end::: :::row::: :::column::: sp_helprolemember :::column-end::: :::column::: sp_helprotect (Deprecated) :::column-end::: :::row-end::: :::row::: :::column::: sp_helpsrvrole :::column-end::: :::column::: sp_helpsrvrolemember :::column-end::: :::row-end::: :::row::: :::column::: sp_helpuser (Deprecated) :::column-end::: :::column::: sp_migrate_user_to_contained :::column-end::: :::row-end::: :::row::: :::column::: sp_MShasdbaccess :::column-end::: :::column::: sp_password (Deprecated) :::column-end::: :::row-end::: :::row::: :::column::: sp_refresh_parameter_encryption :::column-end::: :::column::: sp_remoteoption (Deprecated) :::column-end::: :::row-end::: :::row::: :::column::: sp_revokedbaccess (Deprecated) :::column-end::: :::column::: sp_revokelogin (Deprecated) :::column-end::: :::row-end::: :::row::: :::column::: sp_setapprole :::column-end::: :::column::: sp_srvrolepermission (Deprecated) :::column-end::: :::row-end::: :::row::: :::column::: sp_testlinkedserver :::column-end::: :::column::: sp_unsetapprole :::column-end::: :::row-end::: :::row::: :::column::: sp_validatelogins :::column-end::: :::column::: sp_verify_database_ledger :::column-end::: :::row-end::: :::row::: :::column::: sp_verify_database_ledger_from_digest_storage :::column-end::: :::column::: sp_xp_cmdshell_proxy_account :::column-end::: :::row-end:::