如何授予数据库所有者 (DBO) EXTERNAL ACCESS ASSEMBLY 权限? [英] How to grant the database owner (DBO) the EXTERNAL ACCESS ASSEMBLY permission?

问题描述

当我尝试从 .Net 程序集 (.Net 3.5) 在 SQL 2008 中创建程序集时，出现以下错误，错误提示我必须将以下任一属性设置为 true，我该怎么做?

When I try to create assembly in SQL 2008 from .Net assembly (.Net 3.5) I am getting the below error, error says that I have to set either of the below properties as true, how can I do that?

数据库所有者 (DBO) 具有 EXTERNAL ACCESS ASSEMBLY 权限，因为真

The database owner (DBO) has EXTERNAL ACCESS ASSEMBLY permission as TRUE

该数据库在

程序集使用证书或非对称密钥签名具有相应的登录名，具有 EXTERNAL ACCESS ASSEMBLY 权限.

The assembly is signed with a certificate or an asymmetric key that has a corresponding login with EXTERNAL ACCESS ASSEMBLY permission.

完整的错误如下，

为程序集SQLLogger"创建程序集失败，因为程序集SQLLogger"未被授权用于 PERMISSION_SET = EXTERNAL_ACCESS.当以下任一情况为真时，程序集被授权:数据库所有者 (DBO) 具有 EXTERNAL ACCESS ASSEMBLY 权限并且数据库具有 TRUSTWORTHY 数据库属性；或者程序集使用证书或非对称密钥签名，该密钥具有具有 EXTERNAL ACCESS ASSEMBLY 权限的相应登录名.

CREATE ASSEMBLY for assembly 'SQLLogger' failed because assembly 'SQLLogger' is not authorized for PERMISSION_SET = EXTERNAL_ACCESS. The assembly is authorized when either of the following is true: the database owner (DBO) has EXTERNAL ACCESS ASSEMBLY permission and the database has the TRUSTWORTHY database property on; or the assembly is signed with a certificate or an asymmetric key that has a corresponding login with EXTERNAL ACCESS ASSEMBLY permission.

提前致谢！

推荐答案

您必须在项目文件中设置这些设置！当您右键单击您的项目时，从项目配置中单击数据库设置并选择杂项选项卡.您应该会看到类似于我在此处看到的内容:

You must set these settings in the project file! When you right click on your project, click the Database Settings from the project configuration and select the miscellaneous tab. You should see something similar to what I have here:

这与以下问题相同:运行 CLR 存储过程时出错

这篇关于如何授予数据库所有者 (DBO) EXTERNAL ACCESS ASSEMBLY 权限?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！