Enable Auditing

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 page describes how to enable auditing for the database.

Prerequisites

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

Procedure

This procedure is carried out using ConfD.

The ConfD examples are written in Bash on a Linux terminal running the Exasol tool confd_client, which is accessed by connecting to EXAClusterOS on the database nodes using Exasol Deployment Tool (c4). You can also interact with ConfD from an external tool using Python and XML-RPC. For more information, 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:

    confd_client -c db_list

  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: DATABASE_NAME, enable_auditing: true}'

  3. Start the database. For more information, see Start a Database.

Verification

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

confd_client -c db_info -a 'db_name: DATABASE_NAME'

See Also