REVOKE LOGON Syntax - Database Engine 20 - Teradata Vantage

SQL Data Control Language

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Database Engine 20
Teradata Vantage
Release Number
20.00
Published
June 2025
ft:locale
en-US
ft:lastEdition
2025-07-02
dita:mapPath
knb1747160619932.ditamap
dita:ditavalPath
jlp1749501702948.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.