16.10 - Working with GRANT and REVOKE Statements - Teradata Database

Teradata Database Security Administration

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Administration
Security
featnum
B035-1100-161K

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 SQL Data Control Language.

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 SQL Data Control Language.