Teradata admin

Analytics
Enthusiast

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?
1 REPLY
Teradata Employee

Re: Teradata admin

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;