16.10 - Granting and Revoking Logon Privileges - Teradata Database

Teradata Database Security Administration

Product
Teradata Database
Release Number
16.10
Release Date
June 2017
Content Type
Administration
Security
Publication ID
B035-1100-161K
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.

For example:

[GRANT|REVOKE] LOGON ON  hostid  FROM  username

where:

  • hostid can be:
    • A single hostid
    • A comma-separated list of hostids
    • ALL
  • username can be a:
    • Teradata Database 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.