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

  1. Connect to EXAClusterOS (COS) using c4 connect -t <DEPLOYMENT>[.<NODE>]/cos. For example:

    c4 connect -t 1/cos

    In most cases it does not matter on which node you access ConfD. If you do not specify a node, c4 will connect to the first active node in the deployment. The command prompt in COS indicates which node you are connected to: 

    [root@n11 ~]#

    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

See also