Stored procedure di sicurezza (Transact-SQL)Security Stored Procedures (Transact-SQL)

SI APPLICA A: sìSQL Server sìDatabase SQL di Azure noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse APPLIES TO: yesSQL Server yesAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

SQL ServerSQL Server supporta le seguente stored procedure di sistema che vengono utilizzate per gestire la protezione.supports the following system stored procedures that are used to manage security. Alcune di queste stored procedure sono obsoleti ma continuano a essere disponibili per supportare la compatibilità.Some of these stored procedures are deprecated but continue to be available to support backward compatibility. Negli argomenti delle procedure deprecate sarà indicata le relativa sostituzione.The topics for deprecated procedures will list their replacement.

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

Vedere ancheSee Also

Stored procedure di sistema (Transact-SQL) System Stored Procedures (Transact-SQL)
Funzioni di sicurezza (Transact-SQL)Security Functions (Transact-SQL)