Archives of the TeradataForum

Message Posted: Tue, 24 Apr 2007 @ 14:18:55 GMT

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

It is possible to revoke permissions from PUBLIC and this will remove the access from all users. For example:

     REVOKE  SELECT ON "DBC"."Tables" FROM "PUBLIC"

Of course, you would then need to grant this access to EVERYONE that you wanted to have it. Be careful.

Vince Bernard

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