对对象'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'.

我以DNN用户帐户的身份通过SQL Server Management Studio登录数据库，并且在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权限.当我通过转到安全性->用户-> DNNUserLogin->右键单击->属性-> Securables并向下​​滚动以找到sys.sysobjects视图进行检查时，它表示此用户帐户具有dbo的显式权限:复选框被选中.但是我仍然无法以该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屋！