对象“sysobjects"、数据库“mssqlsystemresource"、架构“sys"的 SELECT 权限被拒绝 [英] The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'

问题描述

设置:SQL Server 2005 &DotNetNuke 05.01.02.

SETUP: SQL Server 2005 & DotNetNuke 05.01.02.

这开始于我尝试安装一个 DNN 模块，该模块在其 SQL 脚本中具有select * from dbo.sysobjects".失败并出现以下错误:

This started with me trying to install a DNN Module that had "select * from dbo.sysobjects" in it's SQL scripts. That failed with the following error:

SELECT 权限被拒绝对象sysobjects"，数据库mssqlsystemresource"，架构sys".

The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.

我通过 SQL Server Management Studio 以 DNN 用户帐户登录到数据库，当我尝试在 sysobjects 视图上执行 SELECT 时遇到相同的错误.

I logged into the database via SQL Server Management Studio as the DNN user account, and I get the same error when I try and perform a SELECT on the sysobjects view.

我尝试授予 DNN 用户帐户对该视图的显式 SELECT 权限.当我通过转到 Security -> Users -> DNNUserLogin-> 右键单击​​ -> Properties -> Securables 并向下滚动以找到 sys.sysobjects 视图来检查它时，它说这个用户帐户对 dbo 有明确的权限:和 SELECT复选框被选中.但是我仍然无法以该 DNN 用户帐户的身份在 sysobjects 视图上执行选择.

I tried to grant the DNN user account explicit SELECT permission to that view. When I check it by going to Security -> Users -> DNNUserLogin-> right-click -> Properties -> Securables and scroll down to find the sys.sysobjects view, it says this user account has explicit permissions for dbo: And the SELECT checkbox is checked. But I still cannot perform a select on the sysobjects view as that DNN user account.

我做错了什么?我怎样才能做到这一点?

What am I doing wrong? How can I make this work?

推荐答案

这也是具有拒绝权限的用户的问题；在我匆忙授予权限时，我基本上给了用户一切.否认正在扼杀它.因此，一旦我删除了这些权限，它就起作用了.

This was a problem with the user having deny privileges as well; in my haste to grant permissions I basically gave the user everything. And deny was killing it. So as soon as I removed those permissions it worked.

这篇关于对象“sysobjects"、数据库“mssqlsystemresource"、架构“sys"的 SELECT 权限被拒绝的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！