Turn On Auditing For a Table
In order to tell the system which fields to audit, you must know the name of the table on which the field is located. You must specify the audit table and the audit trail insert program for a table in the table's meta-data.
Note:
Most of the system's table names are fairly intuitive. For example, the user table is called SC_USER, the navigation option table is called CI_NAV_OPT, etc. If you cannot find the table using the search facility on the
Table portal, please contact customer support.
To enable auditing for a table:
• Navigate to the
Table portal and find the table associated with the field(s) for which you want to capture audit information.
• Specify the name of the Audit Table.
Note:Specifying the Audit Table. You can use the audit table that comes supplied with the base package (
CI_AUDIT) to audit multiple tables and fields. All the audit logs are combined in a single table (
CI_AUDIT). However, you can also have a separate audit table for each audited table. Refer to
The Audit Trail File for more information.
• Specify the name of the Audit Program . The product provides two programs. com.splwg.base.domain.common.audit.DefaultTableAuditor is a standard table audit program. In addition com.splwg.base.domain.common.audit.ModifiedTableAuditoris supplied as an alternative. This program does not audit inserts or deletes of empty string data.
CAUTION:
By default, none of a table's fields are marked for audit. Even though you have enabled auditing for a table, you must still specify the fields and actions on those fields to be audited (see below).
Parent topic