A domain user (User1) belonging to the roles public, db_datareader, and db_datawriter on a particular database is getting the following message when he attempts to select from any tables on that database (including newly created test tables):
The SELECT permission was denied on the object 'table1', database 'database1', schema 'dbo'.
This user works perfectly on several of other databases on the same server. It is not explicitly denied permissions at the database or the table level (that I can find at least).
I've tried (to no avail):
- Removing and remapping the user to the database
- Assigning the user to the db_owner role
- Specifically granting select privileges at the database and table levels
The only thing that has made a difference is setting the user to the sysadmin server role - but this is not viable for production.
How else can I troubleshoot this?