> Setting Up Auditing Attributes

Once you know the attribute name and the technical name of the table to track, set up auditing attributes.

   Make this change to your INIT.ORA file: include compatible=8.0.6

 This parameter enables the version 8.0.6 features for the Datastream 7i database instance, allowing multiple triggers of the same type on the same Datastream 7i table.

Follow these steps to set up auditing attributes.

  1. Open the Audit control form (BNAUDC).

  2. Table—Enter the table to audit.

  3. Column—Enter the attribute to audit.

  4. Description—Enter a brief description of the attribute to audit.

  5. Update—Select to track updates.

  6. Insert—Select to track insertions.

  7. Delete—Select to track deletions.

  8. Click Create audit triggers. Datastream 7i creates the triggers and starts auditing the table and field combination.