title: The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'
body: <p>SETUP: SQL Server 2005 &amp; DotNetNuke 05.01.02. </p>
  
  <p>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: </p>
  
  <blockquote>
    <p>The SELECT permission was denied on
    the object 'sysobjects', database
    'mssqlsystemresource', schema 'sys'.</p>
  </blockquote>
  
  <p>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. </p>
  
  <p>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. </p>
  
  <p>What am I doing wrong? How can I make this work?</p>