Purpose
Determines whether the NONTEMPORAL privilege is included when GRANT ALL and REVOKE ALL statements specify a user, database, view, or table. The NONTEMPORAL privilege allows use of NONTEMPORAL operations on temporal tables.
NONTEMPORAL operations delete rows, modify history rows, or change Transaction Time column values on temporal tables that include a Transaction Time column. These operations include NONTEMPORAL DELETE, NONTEMPORAL UPDATE, NONTEMPORAL INSERT, NONTEMPORAL CREATE TABLE AS, and NONTEMPORAL ALTER TABLE.
Field Group
General
Valid Settings
| Setting | Description |
|---|---|
| TRUE | GRANT ALL and REVOKE ALL statements include the NONTEMPORAL privilege |
| FALSE | GRANT ALL and REVOKE ALL statements exclude the NONTEMPORAL privilege |
Default
FALSE
Changes Take Effect
After the DBS Control Record has been written.
Related Topics
For more information on temporal operations, see Teradata Vantage™ - Temporal Table Support , B035-1182 .