October 11, 2007 at 7:02 am
I am getting ther following error with a user using windows authentication:
Select permission denied on object on object 'tablename', database 'databasename', schema 'dbo'.
I have made the user dbo of the database with and db_datareader. I have also given the user the select permission on the individual table, but still get the above error
When I add the user to the sysadmin server role it works fine.
Any help?
Thanks
Danny
October 11, 2007 at 9:21 am
The user must have a DENY permission set at some level. Can the user select against any other table? Check to see what roles the user is part of and what the permissions are for each role. Also check the permissions for the schema and table. Finally verify the user is not in the db_denydatareader db role.
Being part of the sysadmin role overrides all other security settings including any deny privileges.
David
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply