REVOKE LOGON Syntax - Analytics Database - Teradata Vantage

SQL Data Control Language

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
sgu1628111251052.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dvv1472243528022
lifecycle
latest
Product Category
Teradata Vantageā„¢
REVOKE LOGON ON
  { host_id [,...] | ALL }
  { AS DEFAULT |
    { TO | FROM } user_name [,...]
  } [;]

Syntax Elements

host_id
An integer that identifies a mainframe connection or a workstation connection that is currently 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 particular 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.