I had created a role and assigned access rights to the role, later i had assigned the role to user though the user does not have select access on DB. I did cross check and found that the assigned role has select access on requested DB though he can not access the DB. I granted select access explicitely as below
grant select on DB to user;
Issue is now got resolved but I wanted to know why user was not able to access when role had assigned.
Here i would like to tell you, when i assigned same role to the other users they got the access.
I would appreciate your help.
Well, there's an obvious question: Is that Role active, i.e. did the user submit a SET ROLE command or is it set as Default Role for this user?