title: The SELECT permission was denied on the object 'table', database 'db', schema 'dbo'.
body: <p>Im getting this error in my development machine:</p>
  
  <p>"The SELECT permission was denied on the object 'table', database 'db', schema 'dbo'.", and I don't know why, i tried this and don't even work.</p>
  
  <pre><code>GRANT SELECT
  ON my_table
  TO public
  GO
  </code></pre>
  
  <p>And this</p>
  
  <pre><code>GRANT SELECT ON [dbo].my_table TO myUser
  </code></pre>
  
  <p>Im using an XML file to connect to the database:</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="utf-8" ?&gt;
  &lt;Development&gt;
      &lt;Server&gt;localhost&lt;/Server&gt;
      &lt;Db&gt;MyDB&lt;/Db&gt;
      &lt;User&gt;myUser&lt;/User&gt;
      &lt;Pass&gt;myPass&lt;/Pass&gt;
      &lt;IntegratedSecurity&gt;No&lt;/IntegratedSecurity&gt;
  &lt;/Development&gt;
  </code></pre>
  
  <p>The most weird part is the user is in the Security of my Database:
  <a href="http://puu.sh/bWovD/50d4646602.png" rel="nofollow">http://puu.sh/bWovD/50d4646602.png</a></p>
  
  <p>Hope anyone can help me please</p>