Grant Privileges to the SYSTEM User

Before installing P6 EPPM, execute the following steps:

  1. Navigate to the following location, open the designated script in a text editor, and modify the schema user reference to match your actual schema user name:

    \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. From the command line, execute: sqlplus sys/password@<db_tns_names_entry> as sysdba
  3. Go to p6suite\database\scripts\install\PM_<release_level>, and execute manual_script_before_install.sql.

    This script grants SELECT and EXECUTE privileges with grant option to SYSTEM, or a custom DBA username if you prefer to use one, for the following sys objects:

    SELECT

    • sys.DBA_VIEWS
    • sys.V_$TRANSACTION
    • sys.GV_$TRANSACTION

    EXECUTE

    • sys.DBMS_DBMS_REPUTIL
    • sys.DBMS_DBMS_LOB
    • sys.DBMS_SQL
    • sys.DBMS_JOB
    • sys.DBMS_RANDOM

      Note: For more information about the listed sys objects, refer to the Oracle Database documentation.



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

Last Published Monday, October 24, 2016