InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 20:32:21 GMT20http://www.teradata.com/teradataforum/Topic11249-1-1.aspxI 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.ThanksMon, 28 Apr 2008 09:45:51 GMTJustMehttp://www.teradata.com/teradataforum/Topic11249-1-1.aspxno 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';Tue, 22 Apr 2008 11:39:32 GMTemilwuhttp://www.teradata.com/teradataforum/Topic11249-1-1.aspxI 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.Thu, 17 Apr 2008 10:56:51 GMTJustMe