15.10 - ALL - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
Language
English (United States)
Last Update
2018-06-05

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