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 Informix® Guide to SQL: Syntax.