Enabling Oracle Fine Grained Auditing

After completing the final pass of the upgrade, you can re-enable Oracle Fine Grained Auditing (FGA).

To re-enable FGA:

  1. Review the log file generated by running preupgfgareport.sql at the beginning of the upgrade.

  2. Edit the script pscreatefga.sql, generated earlier in the upgrade, to remove any entries that no longer apply to the new release as some of the tables and columns referenced in the script may have been removed during the upgrade.

    You may want to enable FGA on additional tables and columns in the new release.

  3. After editing the script, run the pscreatefga.sql script to re-enable Oracle Fine Grained Auditing.

See ”Preparing for Your PeopleTools Upgrade,” Preserving PeopleTools Configuration Data, Saving Oracle Fine Grained Auditing Information.

See the online product documentation for PeopleTools: Data Management for your new release for more information about administering databases on Oracle.

Properties

Database Orientation Pass Type Products Platforms Languages

Target

All

All

Oracle

All