Archives of the TeradataForum

Message Posted: Wed, 01 Nov 2006 @ 14:09:28 GMT

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

<-- Anonymously Posted: Wednesday, November 01, 2006 08:54 -->

That depends. You can revoke logon "AS DEFAULT" which affects any user that has never had an explicit GRANT/REVOKE. But once you do GRANT/REVOKE at the user level, you must continue to do so; you can't set an ID back to use the default once it has an explicit rule.

If you really want to block ALL users, you may want to look at DISABLE LOGONS command.

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