Granting and Revoking Logon Privileges | Teradata Vantage - 17.10 - Granting and Revoking Logon Privileges - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2022-02-15
dita:mapPath
ppz1593203596223.ditamap
dita:ditavalPath
wrg1590696035526.ditaval
dita:id
zuy1472246340572
You can use the GRANT LOGON or REVOKE LOGON statement to enable or disable:
  • All logons to the database for a particular user
  • Logons to the database by a user through one or more host IDs. For information on setting up host groups, see Restricting Logons by Host Group.

Syntax

{ GRANT | REVOKE } LOGON ON hostid FROM username

Syntax Elements

hostid
One of the following:
  • A single hostid
  • A comma-separated list of hostids
  • ALL
username
One of the following:
  • Vantage username
  • Comma-separated list of user names

A REVOKE LOGON statement affects only future logon attempts. It does not affect currently logged on users. You can restore logon privileges with the GRANT LOGON statement.