Disable Auditing

This page explains how to disable auditing for a database.

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 procedure is carried out using ConfD.

Disabling auditing does not remove 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

The following examples use the command-line tool confd_client in a Linux terminal connected to a database node. For more information about how to use this tool, 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. For example:

    confd_client -c db_list
    - Exasol
  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: Exasol, 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: Exasol'

See Also