User does not have select access on DB

Database
Enthusiast

User does not have select access on DB

Hi,

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.

4 REPLIES
Senior Apprentice

Re: User does not have select access on DB

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?


Enthusiast

Re: User does not have select access on DB

Hi,
The Role is active. It's not a default role, it is a set role.

Thank you.

Enthusiast

Re: User does not have select access on DB

Hi,

 

The Role is active only. It's not a default role, it is a set role.

nr1
Enthusiast

Re: User does not have select access on DB

Set Users Default ROle to ALL Roles and recheck.

Tags (1)