17.05 - ALL - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1144-175K
Language
English (United States)

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 Vantage 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