teradata admin

Database
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?

Kumar
2 REPLIES
Enthusiast

Re: teradata admin

Hi Kumar,

it could be that a specific default role is defined for the User.
try a MODIFY USERx DEFAULT ROLE = ALL;

Pierre
Enthusiast

Re: teradata admin

I tried this but no luck.