Auditing Changes

The Audit option directs Edit to track database changes. To activate the Audit option, select Options > Personal from the menu in the main window, click Edit, and select Auditing Active.

Refer to the Common Elements Manual.

Note: Site management may set Product Options to restrict the use of this option.

The Audit table, called PSTAUDIT2 or PSTAUDIT3, is stored in the Optim™ Directory. You can review the Audit table in the same way you browse any other database table, as long as the table is not protected by database security.

audit table display, described below
Note: Users must have database Insert and Delete authority for the Audit table if the Auditing function is active. To restrict access to the PSTAUDIT2 or PSTAUDIT3 table, Select authority should not be granted.

If the Audit option is active for the table being edited, and the database is unable to write to the Audit Table, Edit does not commit the changes to the row and the row is placed in Error status.

If the Audit option is active and Edit cannot display the new version of an updated or inserted row, Edit does not commit the changes to the row and the row is placed in Locked status. (For example, when a database trigger modifies the row before it is inserted into the database.)