Enable Auditing

This article 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.

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 available on all database nodes. For more information, see ConfD.

  1. Connect to the cluster operating system (COS) using c4 connect -i PLAY_ID -s cos. For example:

    ./c4 connect -i c3275f84 -s cos

    For more information about how to use c4 connect, see How to use c4.

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

    confd_client db_list
    - MY_DATABASE

  3. If the database is running, stop it now using the ConfD job db_stop. For example:

    confd_client db_stop db_name: MY_DATABASE

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

    confd_client db_configure db_name: MY_DATABASE enable_auditing: true

  5. Start the database using the ConfD job db_start. For example:

    confd_client db_start db_name: MY_DATABASE

Verification

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

confd_client db_info db_name: MY_DATABASE