Level of auditing granularity

The secure-auditing facility can audit the following events at the fragment level of granularity and shows additional information for fragmented objects:

  • Alter Table (ALTB). The partition list that follows the alter-table operation is in the event record.
  • Create Index (CRIX). The index can be fragmented; the event record includes fragmentation information.
  • Create Table (CRTB). The table can be fragmented; the event record includes fragmentation information.
  • Delete Row (DLRW). The partition and the record ID within the partition are in the event record.
  • Insert Row (INRW). The partition and the record ID within the partition are in the event record.
  • Read Row (RDRW). The partition and the record ID within the partition are in the event record.
  • Update Row (UPRW). The partition and the record ID within the partition are in the event record.
Attention: Use row-level auditing only when absolutely necessary. Row-level auditing slows the database server dramatically and fills audit directories quickly.

For more information about the fields in an audit-event record, see Audit event codes and fields.

In addition, the database server audits the following events to the RESTRICT/CASCADE level:

  • Drop Table (DRTB)
  • Drop View (DRVW)
  • Revoke Table Access (RVTB)

For more information about the corresponding SQL statements, see the HCL OneDB™ Guide to SQL: Syntax.