|
I had assigned a user to a role and granted select permission on a table to the user. But the user says he is unable to select the table. Query is correct. what might be the problem.
(comments are locked)
|
|
Have they been denied because of membership in a different role?
(comments are locked)
|
|
Maybe the user is, or is in a role that has, explicitly been denied the permission? It would also be helpful to see what the error message is that the user gets - relying on the user to say that they can't select isn't the best way!
(comments are locked)
|
|
DENY always overrides a GRANT so the I'd agree with Rob and check database role membership. You don't say if you're using SQL or Windows authentication, but if you're using windows authentication, does your user belong to a Windows group that has different permissions?
(comments are locked)
|
Your answer
Posting the actual message the user gets would help us answer you query. Is he 'unable' to connect or is he 'denied' or is the table not found?