Does either of the following:
- Revokes permission to log on to the database from one or more specific client systems.
- Changes the current system logon defaults.
See GRANT LOGON for information about granting logon privileges.
ANSI Compliance
This statement is a Teradata extension to the ANSI SQL:2011 standard.
Required Privileges
You must have the EXECUTE privilege on the DBC.LogonRule macro to perform REVOKE LOGON.
No checks are made on whether the database names or user names defined in the statement apply to users owned by the requesting user.
If the system cannot verify the submitted statement because the statement specifies a nonvalid user name or a nonvalid host ID, the system returns an error.