The solidDB Audit Trail feature tracks user and schema changes persistently within the solidDB database. The audit trail is controlled by using the Sql.AuditTrailEnabled parameter. When the audit trail is enabled, information about the database activities is written into the SYS_AUDIT_TRAIL system table. Users with administrator rights can query the SYS_AUDIT_TRAIL system table with normal SQL syntax.
When the audit trail is enabled, the system records the following database activities:
▪ Changes in user and login information
▪ Changes in schemas and catalogs
▪ Status of audit trail (including when the audit trail is enabled or disabled, and if any entries are deleted). The status of audit trail is written at server startup.
Only administrators (users with the SYS_ADMIN_ROLE) can query the SYS_AUDIT_TRAIL system table. Administrators are also allowed to delete data from the table; the DELETE statements are also audited (unless the DELETE statement affected zero rows).
In a High Availability setup, only the primary server can write to the audit trail. However, the audit trail must be enabled in both servers. This is because each server records database activities according to the configuration settings in its own solid.ini file. In a switchover (where the original primary server had Sql.AuditTrailEnabled=yes), the new primary server continues to record the changes only if it also has the Sql.AuditTrailEnabled parameter set to yes. The state of the new primary server is stored as a status message in the system table; either AUDIT TRAIL ENABLED (HSB) or AUDIT TRAIL DISABLED (HSB).