Previous | Next | Contents | Index | Navigation | Glossary | Library |
The steps for setting up AuditTrail include:
Have your database administrator grant SELECT privileges on SYS.DBA_TABLES to the APPLSYS account. Normally, this step would already have been done as part of your installation or upgrade.
These are groups of tables and columns, where you do not necessarily need to include all the columns in a given table. You enable auditing for audit groups rather than for individual tables. You would typically group together those tables that belong to the same business process (for example, purchase order tables).
A given table can belong to more than one audit group. If so, the table is audited according to the highest "state" of enabling for any of its groups, where Enabled is the highest, followed by Disable Dump Data, Disable No Growth, and Disable Purge Table, in that order.
You can enable auditing for a maximum of 240 columns for a given table, and you can enable auditing for all types of table columns except LONG, RAW, or LONG RAW. Your audit group must include all columns that make up the primary key for a table; these columns are added to your audit group automatically. Once you have added a column to an audit group, you cannot remove it. See: Audit Groups.
You choose the registered Oracle IDs at your site that you want to audit. This allows you to audit across multiple application installations. When a table is added to an audit group, auditing will automatically be enabled for all installations of the table for which audit is enabled. See: Audit Installations.
Your AuditTrail definitions (and auditing) do not take effect until you run the Audit Trail Update Tables Report. If you change any of your definitions later, you must rerun this program. You run the Audit Trail Update Tables Report from the standard submission (Submit Reports) form.
Attention: AuditTrail requires two database connections. If your operating platform does not automatically support two database connections (e.g., VMS or MPE/XL), then add to your environment file the environment variable FDATDB=<database connect string>.
The program also builds special views you can use to retrieve your audit data for reporting.
Release 10.4 AuditTrail Tables, Triggers and Views
Reporting on Release 11 Audit Information
Disabling AuditTrail and Archiving Audit Data
Previous | Next | Contents | Index | Navigation | Glossary | Library |