User Auditing (Pre 26.1.X)
dbWatch Control Center includes support for User audit logging of all actions performed by a user logged in to a dbWatch Monitor.
Enabling User Auditing (Manual Configuration)
Currently, auditing must be configured manually by editing the “server_configuration.xml” file on the Control Center Server.
Step-by-Step Instructions
1. Stop the dbWatch Server service before making any changes
2. Navigate to the location of the configuration file (typically: “C:/ProgramData/dbWatchControlCenter/config/server/server_configuration.xml” or “/var/dbwatch-controlcenter/config/server/server_configuration.xml”)
3. Make a full backup of the file before editing
4. Replace the empty dbwatch-audit tag with the following XML block inside the root “<server-configuration>” element:
<dbwatch-audit>
<audit-type>1</audit-type>
<audit-type>2</audit-type>
<audit-type>3</audit-type>
<audit-type>4</audit-type>
<audit-type>5</audit-type>
<catalog>C:/ProgramData/dbWatchControlCenter/log/user_audit</catalog>
</dbwatch-audit>
Add or remove the <audit-type> tags as appropriate for your needs.
| Audit type | Description |
|---|---|
| 1 | User reads information from the dbWatch Server |
| 2 | User sets configuration values on the dbWatch Server |
| 3 | User reads information from a database instance |
| 4 | User sets data on a database instance |
| 5 | User login/logout information |
5. Save the file and restart the dbWatch Server.