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 this Teradata QueryGrid 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