Archives of the TeradataForum

Message Posted: Fri, 18 Jul 2003 @ 07:23:59 GMT

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

Using a stored proc with some dynamic SQL would be the slickest way to do this (refer to manuals and DBC.SYSEXECSQL.) You could make it parameter driven, give it a database, get the table names then generate you SQL and call it. I use this sort of method for creating users and controlling access rights and it works a treat. To you its just one call but you are still running all the grants, you just don't have to code them.

Cheers

Andy

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