|
|
|
Junior Member
 
Group: Forum Members
Last Login: 6/4/2008 10:34:59 AM
Posts: 21,
Visits: 23
|
|
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.
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 4/22/2008 11:38:42 AM
Posts: 4,
Visits: 11
|
|
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';
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 6/4/2008 10:34:59 AM
Posts: 21,
Visits: 23
|
|
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
|
|
|
|