安全存储过程 (Transact-SQL)Security Stored Procedures (Transact-SQL)

适用对象:是SQL Server 是Azure SQL 数据库 否Azure Synapse Analytics (SQL DW) 否并行数据仓库 APPLIES TO: yesSQL Server yesAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

SQL ServerSQL 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_assemblysys.sp_add_trusted_assembly sp_addapprole (已弃用)sp_addapprole (Deprecated)
sp_addlinkedserversp_addlinkedserver sp_addlinkedsrvloginsp_addlinkedsrvlogin
sp_addlogin (已弃用)sp_addlogin (Deprecated) sp_addremotelogin (已弃用)sp_addremotelogin (Deprecated)
sp_addrole (已弃用)sp_addrole (Deprecated) sp_addrolemember (已弃用)sp_addrolemember (Deprecated)
sp_addserver (已弃用)sp_addserver (Deprecated) sp_addsrvrolemember (已弃用)sp_addsrvrolemember (Deprecated)
sp_adduser (已弃用)sp_adduser (Deprecated) sp_approlepassword (已弃用)sp_approlepassword (Deprecated)
sp_audit_writesp_audit_write sp_change_users_loginsp_change_users_login
sp_changedbownersp_changedbowner sp_changeobjectowner (已弃用)sp_changeobjectowner (Deprecated)
sp_control_dbmasterkey_passwordsp_control_dbmasterkey_password sp_dbfixedrolepermission (已弃用)sp_dbfixedrolepermission (Deprecated)
sp_defaultdb (已弃用)sp_defaultdb (Deprecated) sp_defaultlanguage (已弃用)sp_defaultlanguage (Deprecated)
sp_denylogin (已弃用)sp_denylogin (Deprecated) sp_describe_parameter_encryptionsp_describe_parameter_encryption
sp_dropalias (已弃用)sp_dropalias (Deprecated) sys.sp_drop_trusted_assemblysys.sp_drop_trusted_assembly
sp_dropapprole (已弃用)sp_dropapprole (Deprecated) sp_droplinkedsrvloginsp_droplinkedsrvlogin
sp_droplogin (已弃用)sp_droplogin (Deprecated) sp_dropremotelogin (已弃用)sp_dropremotelogin (Deprecated)
sp_droprole (已弃用)sp_droprole (Deprecated) sp_droprolemember (已弃用)sp_droprolemember (Deprecated)
sp_dropserversp_dropserver sp_dropsrvrolemember (已弃用)sp_dropsrvrolemember (Deprecated)
sp_dropuser (已弃用)sp_dropuser (Deprecated) sp_grantdbaccess (已弃用)sp_grantdbaccess (Deprecated)
sp_grantlogin (已弃用)sp_grantlogin (Deprecated) sp_helpdbfixedrolesp_helpdbfixedrole
sp_helplinkedsrvloginsp_helplinkedsrvlogin sp_helploginssp_helplogins
sp_helpntgroupsp_helpntgroup sp_helpremotelogin (已弃用)sp_helpremotelogin (Deprecated)
sp_helprolesp_helprole sp_helprolemembersp_helprolemember
sp_helprotect (已弃用)sp_helprotect (Deprecated) sp_helpsrvrolesp_helpsrvrole
sp_helpsrvrolemembersp_helpsrvrolemember sp_helpuser (已弃用)sp_helpuser (Deprecated)
sp_migrate_user_to_containedsp_migrate_user_to_contained sp_MShasdbaccesssp_MShasdbaccess
sp_password (已弃用)sp_password (Deprecated) sp_refresh_parameter_encryptionsp_refresh_parameter_encryption
sp_remoteoption (已弃用)sp_remoteoption (Deprecated) sp_revokedbaccess (已弃用)sp_revokedbaccess (Deprecated)
sp_revokelogin (已弃用)sp_revokelogin (Deprecated) sp_setapprolesp_setapprole
sp_srvrolepermission (已弃用)sp_srvrolepermission (Deprecated) sp_testlinkedserversp_testlinkedserver
sp_unsetapprolesp_unsetapprole sp_validateloginssp_validatelogins
sp_xp_cmdshell_proxy_accountsp_xp_cmdshell_proxy_account

请参阅See Also

系统存储过程 (Transact-SQL) System Stored Procedures (Transact-SQL)
安全函数 (Transact-SQL)Security Functions (Transact-SQL)