17.10 - Enabling Logging with the BEGIN LOGGING Statement - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Security Administration

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
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.

Basic Syntax

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

Syntax Elements

Frequency with which logging of an event takes place during a session: FIRST, LAST, FIRST AND LAST, or EACH.
Action or list of actions which, if present in a user request, triggers logging.
Name of the user (or users) for which the system logs requests.
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 Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.