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. You can also access ConfD through XML-RPC in your own Python programs. For more information, see ConfD.

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

    Example:
    Copy 
    ./c4 connect -i c3275f84 -s cos

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

  2. To find the database name when you are connected to COS, use the ConfD job db_list.

    Example:
    Copy 
    confd_client db_list
    - MY_DATABASE

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

    Copy 
    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:

    Copy 
    confd_client db_configure db_name: MY_DATABASE enable_auditing: true

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

    Copy 
    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:

Copy 
confd_client db_info db_name: MY_DATABASE