Archives of the TeradataForum

Message Posted: Wed, 08 Jul 2009 @ 07:23:17 GMT

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

With John's help we did implement similar process at our site. Here's what we did!

Thanks John!

     CREATE ROLE TMGR_ACCESS_ROLE;
     GRANT TMGR_ACCESS_ROLE TO SomeUserID;


     GRANT SELECT ON DBCMNGR.TMGRProfile TO TMGR_ACCESS_ROLE;
     GRANT SELECT ON DBCMNGR.TMGRProfileUser TO TMGR_ACCESS_ROLE;

     INSERT INTO DBCMNGR.TMGRProfileUser
     VALUES ('READ_ONLY_MGR', 'SOMEUserID', 'F');

Thanks,

Vinay Bagare

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