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.
-
To find the name of the database, use the ConfD job db_list:
-
To enable auditing, use the ConfD job db_configure and set
enable_auditing
totrue
. For example: -
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: