title: The SELECT permission on table of user's own schema was denied
body: <p>I have two applications on VB 6.0, AppOK and AppFailed. Both are connecting with a database on SQL Server with user AppUser and querying a table. AppOK succeeds and AppFailed fails with following error message.</p>
  
  <blockquote>
    <p>Run-time error '-2147217911 (80040e09)':</p>
    
    <p>The SELECT permission was denied on the object 'xxxxx', database
    'xxxxx', schema 'xxxxx'.</p>
  </blockquote>
  
  <p>The table exists in AppUser's schema and when i grant the <code>SELECT</code> permission to the user explicitly it says</p>
  
  <blockquote>
    <p>Cannot grant, deny, or revoke permissions to sa, dbo, entity owner,
    information_schema, sys, or yourself.</p>
  </blockquote>
  
  <p>The AppFailed is able to query all other tables within the schema but fails on newly created 4 tables while AppOK can query all of them.</p>
  
  <p>The Connection String of both the applications are exactly the same. Querying those 4 new tables via Management Studio while connected with AppUser works fine. The AppUser does not have any <code>DENY</code> permission.</p>
  
  <p>I am unable to figure out the problem.</p>