16.10 - Enabling Logging with the BEGIN LOGGING Statement - Teradata Database

Teradata Database Security Administration

Teradata Database
Release Number
Release Date
June 2017
Content Type
Publication ID
English (United States)

You can use the BEGIN LOGGING statement to start access logging. BEGIN LOGGING statements have the following results:

  • Each BEGIN LOGGING statement creates a logging rule, in the form of an entry in the DBC.AccLogRule table.
  • Each time a user request matches one of the logging rules found in the DBC.AccLogRuleTbl, the macro creates an entry in the DBC.AccLogTbl.

The basic form of the BEGIN LOGGING statement is:

BEGIN LOGGING ON [frequency] [operation] BY  username  ON  object_name  ;


The Syntax Element... Specifies the...
frequency frequency with which logging of an event takes place during a session: FIRST, LAST, FIRST AND LAST, or EACH.
operation action or list of actions which, if present in a user request, triggers logging.
username name of the user (or users) for which the system logs requests.
object_name name of a database object which, if present in a user request, triggers logging.
BEGIN LOGGING parameters are optional. The absence of some parameters causes the system to use default values.

For a detailed description of BEGIN LOGGING syntax and options, see SQL Data Definition Language Syntax and Examples.