Grant Privileges to the SYSTEM User

Previous TopicNext TopicContents

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 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

    EXECUTE



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

Last Published Thursday, February 04, 2016

PDF Library