15.10 - ALL - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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