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

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 是Azure SQL 数据库Azure SQL DatabaseYesAzure SQL 数据库Azure SQL Database适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 是Azure SQL 数据库Azure SQL DatabaseYesAzure SQL 数据库Azure SQL Database

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.

sp_addapprole (已弃用)sp_addapprole (Deprecated)

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_change_users_login (已弃用)sp_change_users_login (Deprecated)

sp_changedbowner (已弃用)sp_changedbowner (Deprecated)

sp_changeobjectowner (已弃用)sp_changeobjectowner (Deprecated)

sp_defaultdb (已弃用)sp_defaultdb (Deprecated)

sp_defaultlanguage (已弃用)sp_defaultlanguage (Deprecated)

sp_denylogin (已弃用)sp_denylogin (Deprecated)

sp_dropalias (已弃用)sp_dropalias (Deprecated)

sp_dropapprole (已弃用)sp_dropapprole (Deprecated)

sp_droplogin (已弃用)sp_droplogin (Deprecated)

sp_dropremotelogin (已弃用)sp_dropremotelogin (Deprecated)

sp_droprole (已弃用)sp_droprole (Deprecated)

sp_droprolemember (已弃用)sp_droprolemember (Deprecated)

sp_dropsrvrolemember (已弃用)sp_dropsrvrolemember (Deprecated)

sp_dropuser (已弃用)sp_dropuser (Deprecated)

sp_grantdbaccess (已弃用)sp_grantdbaccess (Deprecated)

sp_grantlogin (已弃用)sp_grantlogin (Deprecated)

sp_helpremotelogin (已弃用)sp_helpremotelogin (Deprecated)

sp_helprotect (已弃用)sp_helprotect (Deprecated)

sp_helpuser (已弃用)sp_helpuser (Deprecated)

sp_password (已弃用)sp_password (Deprecated)

sp_remoteoption (已弃用)sp_remoteoption (Deprecated)

sp_revokedbaccess (已弃用)sp_revokedbaccess (Deprecated)

sp_revokelogin (已弃用)sp_revokelogin (Deprecated)

sp_srvrolepermission (已弃用)sp_srvrolepermission (Deprecated)

另请参阅See Also

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