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
Release Date
July 2021
Content Type
Administration
Security
Publication ID
B035-1100-171K
Language
English (United States)
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.