Grant Privileges to the SYSTEM User

Previous TopicNext TopicContents

Before upgrading P6 EPPM on an Oracle database, execute the following scripts:

  1. Navigate to the following locations, open the designated scripts in a text editor, and modify the schema user references to match your actual schema user names:
    1. \scripts\install\PM_<release level>\manual_script_before_upgrade.sql

      If you are not using the schema names admuser or pxrptuser, update the references with your actual admuser and pxrptuser names.

    2. \scripts\install\PM_<release level>\manual_script_before_install.sql

      You must apply grant options to the SYSTEM schema user or a custom user associated with the Oracle DBA role. If you plan to use a custom schema user, other than SYSTEM, to execute steps which require a DBA role, then you must update the references to SYSTEM in the script with the new custom schema user associated with the DBA role.

  2. Execute the following steps:
    1. From the command line, execute: sqlplus sys/password@<db_tns_names_entry> as sysdba
    2. Go to \scripts\install\PM_<release_level> and execute the manual_script_before_upgrade.sql script.
    3. Go to \scripts\install\PM_<release_level> and execute the manual_script_before_install.sql script.


Legal Notices
Copyright © 1999, 2016, Oracle and/or its affiliates. All rights reserved.

Last Published Thursday, February 04, 2016

PDF Library