Before installing P6 EPPM, you must complete the following steps to grant required privileges to your database SYSTEM user.
To grant privileges to the SYSTEM user:
- 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.sqlYou 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 run 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.
- From the command line, run the following and provide the password when prompted:
sqlplus sys@<db_tns_names_entry> as sysdba - Go to p6suite\database\scripts\install\PM_<release_level>, and run 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_REPUTIL
- sys.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.