The SELECT permission was denied on the object ‘Users’, database ‘XXX’, schema ‘dbo’
I think the problem is with the user having deny privileges. This error comes when the user which you have created does not have the sufficient privileges to access your tables in the database. Do grant the privilege to the user in order to get what you want. GRANT the user specific permissions such as SELECT, INSERT, … Read more