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.
-
Connect to EXAClusterOS (COS) on the cluster using
c4 connect -t <DEPLOYMENT>[.<NODE>]/cos
. For example:If you do not specify a node, c4 will connect to the first active node in the deployment.
For more information about how to use
c4 connect
, see How to use c4. -
To find the name of the database, use the ConfD job db_list. For example:
-
If the database is running, stop it now using the ConfD job db_stop. For example:
-
To enable auditing, use the ConfD job db_configure and set
enable_auditing
totrue
. For example: -
Start the database using the ConfD job db_start. For example:
Verification
To verify that the database is configured with the new properties, use the ConfD job db_info. For example: