The audit trail is controlled with the Sql.AuditTrailEnabled parameter. The access mode of the Sql.AuditTrailEnabled parameter is RO (read-only).
To enable audit trail
1 Set the Sql.AuditTrailEnabled parameter to yes in the solid.ini configuration file.
[SQL] AuditTrailEnabled=yes
2 Restart solidDB®.
At the startup, the system writes a status message to the SYS_AUDIT_TRAIL system table to indicate that audit trail is enabled. Changes in database activities are recorded in the SYS_AUDIT_TRAIL system table until audit trail is disabled.
To disable audit trail
1 Set the Sql.AuditTrailEnabled parameter to no in the solid.ini configuration file.
2 Restart solidDB®.
At the startup, the system writes a STATUS message to the SYS_AUDIT_TRAIL system table to indicate that audit trail is disabled. Changes in database activities are not recorded in the SYS_AUDIT_TRAIL system table until audit trail is enabled again.