GRANT Syntax Elements (Temporal Form) - Analytics Database - Teradata Vantage

Temporal Table Support

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-10-30
dita:mapPath
eud1628112402879.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
fif1472244754791
lifecycle
latest
Product Category
Teradata Vantage™
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.