Try OpenEdge Now
skip to main content
Database Administration
Protecting Your Data : Auditing : Auditing tables
 

Auditing tables

Enabling your database for auditing creates seven new tables in your database meta-schema. The table below briefly describes each of the tables. The details on the fields and indexes of each of these tables are discussed in OpenEdge Getting Started: Core Business Services - Security and Auditing.
Table 32. Auditing meta-schema tables
Table name
Description
Archived
_aud-audit-data
This table contains the audit data records. All events are stored in this table.
Yes
_aud-audit-data-value
This table is a child table of the _aud-audit-data table, and contains records for each field change data event.
Yes
_aud-audit-policy
This table contains named audit policies. If multiple policies are active, the aggregation of the policies is applied, and the highest level of auditing will be applied if a conflict exists between policies.
No
_aud-event
This table contains the definitions for all supported OpenEdge and user-defined audit events and their event ids. All event ids up to 32,000 are reserved. You can create custom application events with ids greater than 32,000.
Yes
_aud-event-policy
This table contains policy settings for events associated with policies.
No
_aud-field-policy
This table contains field level auditing settings associated with a named policy.
No
_aud-file-policy
This table contains table level auditing settings associated with a named policy.
No
* Indexes on auditing tables