Use the Audit page of the Preferences window to enable and configure the
audit system for QMF.
About this task
To enable and configure the audit system:
Procedure
-
From the main menu, select .
-
On the left side of the window, select Audit.
-
Select the Enable audit check box.
-
To set the audit system to record only failed events, select the Record failed
events only check box.
-
In the Backup interval (days) field, specify a time interval to define
how often database backup files are created.
Note: After backup files are created, the original database is cleared.
-
In the Delete all backup files older than (days) field, specify an age
for database backup files to be deleted.
-
Select the Record SQL statements for users check box to set the audit
system to record SQL statements made by users for queries against the database.
- Select All Users to record SQL statements made by all users.
- Click the Specify Users... button to open the Data Source
Users dialog and specify particular users. Click OK to accept the
changes or Cancel to leave the dialog without saving the changes.
-
Click Apply to apply the settings and remain on the page or click
Apply and Close to apply the settings and close the window.
Results
After audit is enabled, all information that is gathered by the audit system is saved to the
tables under the AUDIT
schema in an H2 database. This database is created in the
application data folder. The summarized information from all the tables is presented in the
AUDIT_VIEW
table. For information about reading audit records, see Using the audit system.