title: The SELECT permission was denied on the object '<Table_Name>', database '<Database_Name>', schema 'dbo'. - ASP.NET/SQL Server
body: <p>I have a database "Sample". And there is a user in Active Directory (AD) called "CORPHQ\King". I have followed these steps:</p>
  
  <pre><code>1) Go to SQL Server Management Studio (2005) and "Security -&gt; Logins".
  2) Right Click -&gt; New Login
  3) Login Name : CORPHQ\King
  4) Selected "Windows Authentication"
  5) Default database - "Sample".
  6) Under "User Mapping" section, Selected the "Sample" database, User as "CORPHQ\King" and selected "dbo" as default schema.
  7) Selected "db_owner" as "Database role membership for - Sample".
  </code></pre>
  
  <p>Now in the WEB.CONFIG of the ASP.NET application, i do have:</p>
  
  <pre><code>&lt;connectionStrings&gt;
      &lt;add name="DB" connectionString="Data Source=128.127.126.25; database=Sample; user=corphq\King; password=XXXXXXXXXXX; Integrated Security=SSPI;" providerName="System.Data.SqlClient"/&gt;
  &lt;/connectionStrings&gt;
  </code></pre>
  
  <p>Now when i ran the ASP.NET application, i am getting the error mentioned:</p>
  
  <pre><code>Error:
  
  The SELECT permission was denied on the object 'tbl_Student', database 'Sample', schema 'dbo'
  </code></pre>
  
  <p>I think so user "CORPHQ\King" has the "db_owner" access to "Sample" database. Am i correct ? Where am i missing ?</p>
  
  <p>Thanks</p>