HP 3000 Manuals HP 3000 Manuals
Auditing DBEnvironments Audit DBEnvironments are created with SQL statements that allow you to generate audit log records. Audit log records contain information that allows you to group log records for analysis with SQLAudit. The database operations you might analyze are UPDATE, INSERT, or DELETE operations, perhaps for security reasons. Audit log records contain identifiers such as table names in contrast to non-audit database log records which contain identifiers such as page references and data. Audit log records are generated in addition to non-audit database log records. A unique audit name specifies an audit DBEnvironment. Audit elements indicate which ALLBASE/SQL statement types generate audit log records. By default, statements that change data generate audit log records (INSERT, UPDATE, and DELETE statements); this default can also be specified explicitly by the DATA AUDIT ELEMENTS parameter. You can also optionally specify that log comment, data definition, authorization, or section statements (creation and deletion of sections) generate audit log records. The Audit Tool, SQLAudit, is introduced below. SQLAudit is fully described in the ALLBASE/SQL Database Administration Guide. The ALLBASE/SQL Database Administration Guide describes how to create audit DBEnvironments and how to select records for audit. The "SQL Statements" chapter of this manual contains the detailed syntax to create audit DBEnvironments and partitions. Partitions in Audit DBEnvironments Partitions are divisions of DBEnvironments that contain one or more tables processed by SQLAudit as a unit. Partitions are specified in CREATE PARTITION, CREATE TABLE, and ALTER TABLE statements. In addition, default partition and comment partition numbers can optionally be specified.