sys.sp_drop_trusted_assembly (Transact-SQL)sys.sp_drop_trusted_assembly (Transact-SQL)

适用于: 是SQL Server 2017 及更高版本 否Azure SQL 数据库 否Azure Synapse Analytics (SQL DW) 否并行数据仓库 APPLIES TO: yesSQL Server 2017 and later noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

从服务器上的受信任程序集列表中删除程序集。Drops an assembly from the list of trusted assemblies on the server.

主题链接图标 Transact-SQL 语法约定Topic link icon Transact-SQL Syntax Conventions

语法Syntax

sp_drop_trusted_assembly 
    [ @hash = ] 'value'

参数Arguments

[ @hash = ]"value"[ @hash = ] 'value'
要从服务器的受信任程序集列表中删除的程序集的 SHA2_512 哈希值。The SHA2_512 hash value of the assembly to drop from the list of trusted assemblies for the server. 即使程序集未签名或数据库未标记为可信,也可以在启用 clr 严格安全时加载受信任的程序集。Trusted assemblies may load when clr strict security is enabled, even if the assembly is unsigned or the database is not marked as trustworthy.

备注Remarks

此过程从 sys.databases 中删除程序集。 trusted_assembliesThis procedure removes an assembly from sys.trusted_assemblies.

权限Permissions

要求具有固定服务器sysadmin角色或CONTROL SERVER权限的成员身份。Requires membership in the sysadmin fixed server role or CONTROL SERVER permission.

示例Examples

下面的示例从服务器的受信任程序集列表中删除程序集哈希。The following example drops an assembly hash from the list of trusted assemblies for the server.

EXEC sp_drop_trusted_assembly 
0x8893AD6D78D14EE43DF482E2EAD44123E3A0B684A8873C3F7BF3B5E8D8F09503F3E62370CE742BBC96FE3394477214B84C7C1B0F7A04DCC788FA99C2C09DFCCC; 

另请参阅See Also

trusted_assemblies DROP assembly (transact-sql) sp_add_trusted_assemblysys.sp_add_trusted_assembly sys.trusted_assemblies DROP ASSEMBLY (Transact-SQL)
sys.assembliessys.assemblies
sys.dm_clr_loaded_assembliessys.dm_clr_loaded_assemblies