Archives of the TeradataForum

Message Posted: Wed, 01 Nov 2006 @ 14:07:13 GMT

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

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

Is there a simpler way to GRANT/REVOKE logons for all users beside submitting individual commands for each user?

Check the documentation on SQL reference on subject of grant or revoke logon. You will find the details of grant logon by default; or revoke logon by default; which is suppose to do what you are asking for. There are exceptions for the users having been granted or revoked individually already when that command was issued.

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