Archives of the TeradataForum

Message Posted: Tue, 14 Dec 2004 @ 22:43:16 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I've noticed this statement from the manual does not work:

     GRANT ALL ON ALL TO DBADMIN ;

However - an easy, fast way to grab the appropriate rights would be to gen individual GRANT statements by database for dump/restore rights.

Just plug in your new archive ID (mygrantid) and 'dbc' (or system admin ID):

     SELECT DISTINCT 'GRANT ' || TRIM(ACCESSRIGHT) || ' ON ' || TRIM(DATABASENAME) || ' TO mygrantid;'
       FROM  DBC.ALLRIGHTS
       WHERE USERNAME = 'dbc'
       And TRIM(ACCESSRIGHT) In ('DP','RS');

You can also add ",grantauthority" before the FROM to see the grant option.

Cheers,

Lisa

	<Prev	Next>		<<First	<Prev	Next>	Last>>