Purpose
Starts the auditing of SQL requests that attempt to access data.
This topic describes only the portions of the BEGIN LOGGING syntax diagram specific to the Teradata-to-Teradata connector. For information about the other syntax used with BEGIN LOGGING, see Teradata® Database SQL Data Definition Language - Syntax and Examples, B035-1144.
Syntax
BEGIN LOGGING [ DENIALS ] [ WITH TEXT ] ON [ FIRST | LAST | FIRST AND LAST | EACH ] [ FOR CONSTRAINT constraint_name ] { ALL | operation [,...] | GRANT } [ BY { database_name | user_name }[,...] ] [ ON target ] [,...] [;]
Syntax Elements
- target
{ authorization | DATABASE database_name | USER user_name | { TABLE | VIEW | MACRO | PROCEDURE | FUNCTION | TYPE | FOREIGN SERVER } [ database_name. | user_name. ] object_name }
- authorization
AUTHORIZATION authorization_name