17.05 - Required Privileges - Teradata Database

Teradata Vantage™ - Temporal Table Support

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1182-170K

The following privileges are required in addition to those privileges required for a conventional UPDATE statement:

  • If the UPDATE statement specifies the NONTEMPORAL qualifier, the NONTEMPORAL privilege is also required on the temporal table.
  • For a current or sequenced update to a table with valid time, the UPDATE privilege is required on the valid-time column of the table.