17.10 - Working with GRANT and REVOKE Statements - 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)

The GRANT statement has the following variations:

This Statement... Grants or Revokes...
GRANT/REVOKE (SQL Form) database privileges to a user or role.
GRANT/REVOKE (Monitor Form) monitoring privileges for a user or role.

See Teradata Vantage™ - SQL Data Control Language, B035-1149.

GRANT LOGON/REVOKE LOGON logon privileges to a user.

For usage, see About Logon Privileges.

GRANT ROLE/REVOKE ROLE membership in a role for one or more users or other roles.
GRANT CONNECT THROUGH/REVOKE CONNECT THROUGH
  • Trusted user status to a middle-tier application.
  • CONNECT THROUGH privileges to proxy user(s).
  • Use of roles to the specified proxy users.

For GRANT and REVOKE statement syntax and options, see Teradata Vantage™ - SQL Data Control Language, B035-1149.