C.2 Updating PeopleSoft Portal Registry Security

To update PeopleSoft portal registry security:

  1. Copy the PORTAL_CR840_NAVSRTY.DMS file from the currently supported PeopleSoft CRM release on the PeopleSoft PeopleTools 8.5x database <PS_APP_HOME>\scripts directory to the PeopleSoft Portal Solutions database <PS_APP_HOME>\scripts directory.

  2. Copy the PORTAL_CR840_NAVSRTY.DAT file from the currently supported PeopleSoft CRM release on the PeopleSoft PeopleTools 8.5x database <PS_APP_HOME>\data directory to the PeopleSoft Portal Solutions database <PS_APP_HOME>\data directory.

  3. Use PeopleSoft Data Mover to sign on to the PeopleSoft Portal Solutions database in bootstrap mode.

  4. Open the <PS_APP_HOME>\scripts\PORTAL_CR840_NAVSRTY.dms script.

  5. Carefully follow the directions as outlined in the PeopleSoft Data Mover script text.

  6. If you are running on DB2 for z/OS, add the following statement after set input and set log and before import *: 

    SET EXECUTE_SQL SET CURRENT SQLID = 'OBJ#OWNER';

  7. Run this script against the PeopleSoft Portal Solutions database by selecting File, Run Script.

  8. View the output window to ensure that rows have been inserted.

    For customers using PeopleSoft CRM 8.8 or 8.9, 24 rows will be inserted.

  9. Close PeopleSoft Data Mover.