title: Select permission was denied on object
body: <p>Well, I'm creating an app web with Cold Fusion, every time I debug my project in the browser I get this error:</p>
  
  <blockquote>
    <p><em>Error Executing Database Query.</em></p>
    
    <p><em>[Macromedia][SQLServer JDBC Driver][SQLServer] The SELECT permission was denied on the object 'users', database 'hotel', schema 'dbo'</em></p>
  </blockquote>
  
  <p>I'm using a user called <code>CFLogin</code> and I grant to him select permissions through this command in SQL Server:</p>
  
  <pre><code>USE hotel
  GO
  GRANT SELECT ON dbo.users TO CFLogin
  </code></pre>
  
  <p>Also I've executed the follows stored procedures to give roles to my user:</p>
  
  <pre><code>EXEC sp_addrolemember 'db_owner',CFLogin
  EXEC sp_addrolemember 'db_datareader',CFLogin
  EXEC sp_addrolemember 'db_accessadmin',CFLogin
  </code></pre>
  
  <p>But it always results in the same message: <code>Select permission was denied on object...</code> I've even rebooted the service but nothing seems working at all.</p>
  
  <p>What am I doing wrong?</p>
  
  <p>Regards!</p>