Cascading Roles

UDA
Enthusiast

Cascading Roles

I would like to know if there is a way to automatically grant a role to a child.

If UserA owns UserB, UserC, and UserD, I would like to be able to grant role_basic_rights to UserA and have that right automatically granted to UserB, UserC, UserD and any future users that will be owned by UserA.

2 REPLIES
Enthusiast

Re: Cascading Roles

no such thing in teradata, however, you can generate grant statement by using

SELECT 'GRANT BASE_USER_ROLE TO ' ||TRIM(DATABASENAME) ||';' FROM DBC.DATABASES WHERE OWNER = 'A';
Enthusiast

Re: Cascading Roles

I was afraid of that. I couldn't find it anywhere in the documentation or in white papers, I was just hoping....

I know how to generate the SQL, it's just very, very time consuming with the number of users we have.

Thanks