Log into the P6 EPPM database as a SYSTEM or other DBA privileged user.
Execute the orpm_create_users.sql script.
Notes:
Running the orpm_create_users.sql script automatically creates database user names: admuser, privuser, pubuser, and PxRptUser. If you have created other user names and wish to use those when running P6 EPPM database scripts, make sure to replace the administrative, private, public, and PX reporting user names with your custom user names in all applicable scripts before running them.
Do not use special characters in the database name, privileged user, public user, or PX reporting user name, for example: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~ `
As a system user, execute the orpm_grantpriv.sql script.
Log into the P6 EPPM database as admuser, or use your custom administrative user name if you created one.
Execute the orpm_tables.sql script.
Notes:
If you changed tablespace or user names, you will need to update the orpm_tables.sql script. You will need to update the PMDB_DAT1 and PMDB_PX_DAT1 tablespace names and the admuser, privuser, pubuser, and PxRptUser names.
Do not use special characters in the database name, privileged user, public user, or PX reporting user name, for example: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~ `