设置:SQLServer2005&;DotNetNuke 05.01.02.
这始于我试图安装一个DNN模块,该模块的SQL脚本中有"select*from dbo.sysobjects".失败,出现以下错误:
上的SELECT权限被拒绝
我以DNN用户帐户的身份通过SQL Server Management Studio登录到数据库,当我try 在sysobjects视图上执行 Select 时,会出现相同的错误.
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.
我做错了什么?我怎样才能做到这一点?