REVOKE LOGON Syntax Elements - Teradata Vantage

Teradata® VantageCloud Lake

Deployment

VantageCloud

Edition

Lake

Product

Teradata Vantage

Published

January 2023

ft:locale

en-US

ft:lastEdition

2024-12-11

dita:mapPath

phg1621910019905.ditamap

dita:ditavalPath

pny1626732985837.ditaval

dita:id

phg1621910019905

host_id: An integer that identifies a mainframe connection or a workstation connection that is defined to the system by the hardware configuration data. The interface need not be operational.; The value for the database Console is 0.; For any other connector, the value for host_id ranges from 1 through 32,767.
ALL: Any source through which a logon is attempted, including the database Console.
AS DEFAULT: Indicates that the current default for the specified host ID set is to be changed, without residual conditions, as defined in this REVOKE LOGON request.; A request with AS DEFAULT has no effect on the access revoked from or granted to specific user names. A request that sets the default for a specific host ID takes precedence over a request that sets the default for ALL client systems.
TO
FROM: Keywords introduced to override the current default for the specified database_name_list or user_name set on the specified host_ID set.
user_name: One or more user names from whom logons are to be revoked.; The name DBC cannot be specified as a user_name in a REVOKE LOGON request. Any request that specifies the name DBC as a user aborts and returns an error message to the requestor.; The product of the number of host IDs and the number of database and user names cannot exceed 25.