All Forums Analytics
sureshbadam 14 posts Joined 09/07
09 Jul 2009
Teradata admin

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?

Fred 1096 posts Joined 08/04
11 Jul 2009

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 toMODIFY USER User1 AS DEFAULT ROLE = x;orMODIFY USER User1 AS DEFAULT ROLE = ALL;

You must sign in to leave a comment.