Enable Auditing

This page explains how to enable 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.

Prerequisites

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

Procedure

The following examples use ConfD through the command-line tool confd_client, which is accessible on all database nodes. You can also access ConfD through XML-RPC in your own Python programs. For more information, see ConfD.

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

    confd_client -c db_list
    - Exasol

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

    confd_client -c db_configure -a '{db_name: Exasol, enable_auditing: true}'

  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