Saving Oracle Fine Grained Auditing Information

If you have implemented Oracle's Fine Grained Auditing (FGA) feature on PeopleSoft tables, disable it for the duration of the upgrade to improve upgrade performance.

To disable Fine Grained Auditing:

  1. Run PS_HOME\SCRIPTS\preupgfgareport.sql. This script reports on the current (pre-upgrade) FGA policies stored in USER_AUDIT_POLICIES, detailing all columns by table for all tables with FGA policies. Keep this report to use at the end of the final pass of the upgrade.

  2. Run PS_HOME\SCRIPTS\preupgfgaprocess.sql. This script generates the scripts pscreatefga.sql and psdisablefga.sql.

  3. Run the generated psdisablefga.sql to disable FGA polices.

You will run the generated pscreatefga.sql script at the end of the final pass of the upgrade. Do not run it at this time.

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

See “Completing Database Changes,” Enabling Oracle Fine Grained Auditing.

Properties

Database Orientation Pass Type Products Platforms Languages

Target

All

All

Oracle

All