Previous	Next		Contents	Index	Navigation	Glossary	Library

First identify the columns in a table you want to audit. Then, using the Audit Groups window, include the table as part of an audit group. Or, you may define your audit group first (using the Audit Groups window), and then select which columns in the table you want to audit (using this window).

To enable or disable auditing for the tables in your audit group (i.e., the columns you have selected here), you must run the Audit Trail Update Tables program using the Submit Requests window. If you select additional columns to audit, or change the definition or audit state of your group later, you must rerun this program.

Prerequisites

• Define an audit installation using the Audit Installations window.

Attention: Your tables and their primary key information must already be registered and defined for successful auditing. If the table you want to audit is a custom table (not shipped as part of Oracle Applications), you should also perform the following two steps:

• Register your table and its primary key columns using Oracle Application Object Library's Tables window (Application Developer Responsibility).

• Run the Register Tables concurrent program from the Submit Requests window.

User Table Name

Select the end user table name (frequently the same name as the table name) for your database table. Once you choose a table, you see its table name and associated application.

Table Name

This field displays the actual name for the table you have selected to include in your audit group.

Application

This field displays the application name for the table you have selected to include in your audit group.

• You cannot delete a column from auditing once it has been selected.

• You may add additional columns to be audited.

• Each time you select a column to be audited, that change affects every audit group that includes the table which owns the column.

Enter the name of the database column you want to audit. You should not explicitly enter the names of your table's primary key columns, since they are entered automatically, and you will get an error message if you try to save a duplicate column name. You can query to see which columns appear automatically.

Note that once you have chosen a column, you cannot delete it from the audit set, though you may add other columns to the set later.

Once you choose a column, you see its column type and whether it is part of the primary key for this table.

Column Type

This field describes the type of data the column stores, for example, varchar2.

Primary Key

This field displays Yes or No indicating whether the column you are auditing is a primary key column.

Any primary key columns you do not select to audit are automatically included when you save your column selections. For example, if the table you are auditing has two primary key columns, and you choose to audit one of them, the second primary key column is automatically selected when you save your column selections.

See Also

Reporting on AuditTrail Data

Setting Up Release 11 AuditTrail

Release 10.4 AuditTrail Tables, Triggers, and Views

Reporting on Release 11 Audit Information

Disabling AuditTrail and Archiving Audit Data

Audit Installations

Audit Groups