Security stored procedures (Transact-SQL)

Artikel
2024-08-23

Applies to: SQL Server Azure SQL Database

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.

sys.sp_add_trusted_assembly

sp_addapprole (Deprecated)

sp_addlinkedserver

sp_addlinkedsrvlogin

sp_addlogin (Deprecated)

sp_addremotelogin (Deprecated)

sp_addrole (Deprecated)

sp_addrolemember (Deprecated)

sp_addserver (Deprecated)

sp_addsrvrolemember (Deprecated)

sp_adduser (Deprecated)

sp_approlepassword (Deprecated)

sp_change_users_login (Deprecated)

sp_changedbowner (Deprecated)

sp_changeobjectowner (Deprecated)

sp_control_dbmasterkey_password

sys.sp_copy_data_in_batches

sp_dbfixedrolepermission (Deprecated)

sp_defaultdb (Deprecated)

sp_defaultlanguage (Deprecated)

sp_denylogin (Deprecated)

sp_describe_parameter_encryption

sp_dropalias (Deprecated)

sys.sp_drop_trusted_assembly

sp_dropapprole (Deprecated)

sp_droplinkedsrvlogin

sp_droplogin (Deprecated)

sp_dropremotelogin (Deprecated)

sp_droprole (Deprecated)

sp_droprolemember (Deprecated)

sp_dropsrvrolemember (Deprecated)

sp_dropuser (Deprecated)

sys.sp_generate_database_ledger_digest

sp_external_policy_refresh

sp_grantdbaccess (Deprecated)

sp_grantlogin (Deprecated)

sp_helpdbfixedrole

sp_helplinkedsrvlogin

sp_helpremotelogin (Deprecated)

sp_helprolemember

sp_helprotect (Deprecated)

sp_helpsrvrolemember

sp_helpuser (Deprecated)

sp_migrate_user_to_contained

sp_MShasdbaccess

sp_password (Deprecated)

sp_refresh_parameter_encryption

sp_remoteoption (Deprecated)

sp_revokedbaccess (Deprecated)

sp_revokelogin (Deprecated)

sp_srvrolepermission (Deprecated)

sp_testlinkedserver

sp_unsetapprole

sp_validatelogins

sys.sp_verify_database_ledger

sys.sp_verify_database_ledger_from_digest_storage

sp_xp_cmdshell_proxy_account