System > Database Auditing

Key Info  
Purpose:

Define fine grain auditing tables.
Related Module(s):

Database
Accessed From:

Maintenance > System > Database Auditing
Window(s):

Database Auditing
Dependencies:

None.

Database Auditing Window

axiUm offers detailed fine grain auditing for any axiUm tables. The information saved includes not only the date, time, workstation, and user that made the change, but the exact details of the changes made. These details are stored in the various audit tables in your database.

The SQL Text and SQL Bind Variables fields show the command used, the record or records that were altered, and values used to alter them.

Activating this feature causes Oracle to populate the DBA_FGA_AUDIT_TRAIL table, which is outside the axiUm schema. This means that if you migrate axiUm to a new database server, this audit information must be accounted for individually.

The Database Auditing window allows you to specify tables to include in fine grain auditing.

Important: Selecting too many tables, or tables that are used frequently may slow axiUm performance.

Task Procedure
Add Tables to Audit
  1. Select one or more tables in the axiUm Tables not being audited list.
  2. Click the > button to move the table(s) to the axiUm Tables being audited list.
Remove Tables from Audit
  1. Select one or more tables in the axiUm Tables being audited list.
  2. Click the < button to move the table(s) to the axiUm Tables not being audited list.