Disable Auditing
This article explains how to disable 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.
Disabling auditing does not remove data that was already saved in the auditing tables. To remove the auditing data, use the TRUNCATE AUDIT LOGS statement.
Prerequisites
The database must be stopped. For more information, see Stop a Database.
Procedure
This procedure uses the command-line tool confd_client, which is available on all database nodes. For more information, see ConfD.
Placeholder values are indicated with UPPERCASE characters. Replace the placeholders with your own values.
-
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. -
To find the database name when you are connected to COS, use the ConfD job db_list.
Example:
Copyconfd_client db_list
- MY_DATABASE -
To disable auditing, use the ConfD job db_configure and set
enable_auditing
tofalse
. For example:Copyconfd_client db_configure db_name: MY_DATABASE enable_auditing: false
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