Disable Auditing

The auditing function in Exasol captures details for every session and every executed SQL statement. Auditing is enabled by default on a new database. For more information, see Auditing.

This page describes how to disable auditing for the database.

Disabling auditing does not remove the data that was already saved in the auditing tables. To remove the auditing data, use the TRUNCATE AUDIT LOGS statement.

Prerequisites

The database must be stopped. For more information, see Stop a Database.

Procedure

This procedure is carried out using ConfD.

The ConfD examples are written in Bash on a Linux terminal running the Exasol tool confd_client, which is accessed by connecting to EXAClusterOS on the database nodes using Exasol Deployment Tool (c4). You can also interact with ConfD from an external tool using Python and XML-RPC. For more information, see ConfD.

Placeholder values are indicated with UPPERCASE characters. Replace the placeholders with your own values.

  1. To find the name of the database, use the ConfD job db_list:

    confd_client -c db_list

  2. To disable auditing, use the ConfD job db_configure and set enable_auditing to false. For example:

    confd_client -c db_configure -a '{db_name: DATABASE_NAME, enable_auditing: false}'

  3. Start the database. For more information, see Start a Database.

Verification

To verify that the database is configured with the new properties, use the ConfD job db_info. For example: 

confd_client -c db_info -a 'db_name: DATABASE_NAME'

See Also