Connect to your database.

Execute the following statement to turn on auditing:

SET OPTION PUBLIC.auditing = 'On';

To specify which types of auditing information you want to enable, use the following system procedure:

CALL sa_enable_auditing_type( 'all' );

You can control the type of auditing information that is collected by replacing all with the types of auditing you want to enable.

Execute the following statement to turn off auditing:

SET OPTION PUBLIC.auditing = 'Off';

To specify which types of auditing information you want to disable, use the following system procedure:

CALL sa_disable_auditing_type( 'all' );

You can stop collecting specific types of auditing information by replacing all with the types of auditing you want to disable.