Archives of the TeradataForum

Message Posted: Wed, 02 Aug 2006 @ 15:08:04 GMT

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

Has anyone developed a Stored Procedure that accepts a database name as an input parameter and inputs to a table (temp or perm) all GRANT SQL statements that have been a used for authorizations to this database? (I do not think a Macro could be used to do this) For example, call Grant_SP ('dbname') would create a rows of text in a table such as:

     GRANT SELECT ,INSERT ,UPDATE ,DELETE ON dbname TO USER1 WITH GRANT
     OPTION;
     GRANT INSERT  ON dbname TO Role1;
     etc.

Any sample Stored Procedure code would be greatly appreciated.

Thanks

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