17.10 - GRANT Syntax Elements (Temporal Form) - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Temporal Table Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1182-171K
Language
English (United States)
ALL [PRIVILEGES]
Specifies that the specified user is to receive all privileges that can be granted on the specified object.
GRANT ALL includes the NONTEMPORAL privilege if the InclNTforGrntOrRevokAll field of the DBS Control utility is set to TRUE. Otherwise, GRANT ALL excludes the NONTEMPORAL privilege.
All of the privileges, including the NONTEMPORAL privilege, that the grantor has on the object are granted if a user has them with WITH GRANT OPTION.
NONTEMPORAL
Specifies that the user can use the NONTEMPORAL prefix to perform nontemporal operations on transaction-time and bitemporal tables contained in database_name or user_name, on table_name, or on view_name.
privilege
Specifies a privilege other than NONTEMPORAL.

For details, see Teradata Vantage™ - SQL Data Control Language, B035-1149.

ALL BUT
Specifies that the named user is to receive all privileges that can be granted on the specified object except for those specified in the privilege list. As in ALL, only those object privileges owned by the grantor WITH GRANT OPTION are granted.
ON database_name
Specifies the name of a database that contains or may contain transaction-time or bitemporal tables or both.
ON user_name
Specifies the name of a user that contains or may contain transaction-time tables, bitemporal tables, or both.
ON table_name
Specifies the name of a transaction-time or bitemporal table.
ON view_name
Specifies the name of an updatable view created on a transaction-time or bitemporal table.
TO [ALL] username
Specifies the name of an existing database or user that identifies the recipient.

If you specify ALL, then the object privileges are granted to the named database or user and to every database or user owned by that database or user now and in the future.

WITH GRANT OPTION
Specifies that the grantee receives the granted privileges WITH GRANT OPTION.