Archives of the TeradataForum

Message Posted: Fri, 30 Jul 2004 @ 18:54:04 GMT

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

Unfortunately, no. The best you can do is run queries that find such grants and generate the statements to revoke them which you can then export and .run. Much more work that you should have to do. If a user has a right with the grant option, it can grant the right to public. At least that only puts one row per right in DBC.AccessRights in V2R5.

Jon

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