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