|
|
|
Junior Member
 
Group: Forum Members
Last Login: 9/9/2009 1:43:59 PM
Posts: 10,
Visits: 20
|
|
I have created a role and granted this role to the user but the user can't access the database that is granted to the role.
I have executed the follwoing.
create role x;
grant select on edw_tb to x;
grant x to user1;
What I am doing wrong here?
Kumar
Datawarehousing Consultant</
|
|
|
|
|
Supreme Being
Group: PAC and SFT Members
Last Login: 9/9/2009 4:34:06 PM
Posts: 407,
Visits: 889
|
|
It's not enough to be permitted to use the role, User1 needs to "assert" the role to actually inherit the permissions. That can be executing an explicit SET ROLE statement after logon, or more likely what you want is to
MODIFY USER User1 AS DEFAULT ROLE = x;
or
MODIFY USER User1 AS DEFAULT ROLE = ALL;
|
|
|
|