Table Level Auditing

Auditing is supported on all stereotyped entity operations except ns, nsmulti, batchinsert and batchmodify.

The information captured by table level auditing is stored in the database table AuditTrail.

Table level auditing is enabled by switching on theDatabase table-level auditing option for an operation. This causes the generated data-access code to record audit information for an operation.

The type of audit information recorded depends on whether optimistic locking is switched on or off for the operation. If optimistic locking is switched on, then the audit information includes the information of the new and old versions of the record, otherwise it only includes information about the SQL operation invoked.