title: Permissions denied on sql query
body: <p>I'm trying to execute the following query through classic asp recordset -</p>
  
  <pre><code>SQL = "Select P_Name as P_Name, P_Description as P_Description 
         from L_PagePermission 
         inner join A_Permission on p_permissionID = pp_PermissionID 
         inner join A_Page on P_PageID = PP_PageID 
         where P_PageID = 85 
         order by p_Name"   
  </code></pre>
  
  <p>Although I've ran into a problem with permissions. So the error that i am receiving is - </p>
  
  <blockquote>
    <p>Microsoft OLE DB Provider for ODBC
    Drivers error '80040e09'</p>
    
    <p>[Microsoft][ODBC SQL Server
    Driver][SQL Server]SELECT permission
    denied on object 'A_Permission',
    database 'HRWB_3_0', schema 'dbo'.</p>
  </blockquote>
  
  <p>How would I go about executing this query without changing permission settings. How can I do this with a stored procedure? (Can someone provide an example too)</p>
  
  <p>I can't change the database settings I have to deal with what I got. I've looked through a lot of the websites files and it seems to be mostly dependent on stored procedures.</p>