16.20 - ALL - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

A log entry is to be made when any of the operations listed in the following row of this table is attempted against the specified object.

Note that both the name and ID for each column are logged when you log privileges to INSERT, REFERENCES, SELECT, and UPDATE.

If logging has begun for ALL actions on an object, a request to begin or end logging for an action will change logging activity only for the specified action.

The ALL option does not include logging of the following actions because they do not apply to a specific object.

  • CREATE PROFILE
  • CREATE ROLE
  • DROP PROFILE

The ALL option does not apply to the NONTEMPORAL privilege because Teradata Database defines a BEGIN LOGGING rule on it by default (see Teradata Vantage™ Temporal Table Support , B035-1182 for details).

The following restrictions apply to the logging of UDTs:

  • UDTTYPE and UDTMETHOD are only valid when specified with ON DATABASE SYSUDTLIB or ON USER
  • UDTUSAGE is only valid when specified with ON DATABASE SYSUDTLIB, ON USER, or ON TYPE