Log into the P6 EPPM database as a SYSTEM or other DBA privileged user.
As a system user, execute the orpm_grantpriv.sql script.
Execute the orpm_create_users.sql script.
Execute the orppm_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: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~ `
Running the orpm_create_users.sql script automatically creates database user names: admuser, privuser, and pubuser. 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 and public 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, or public user name, for example: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~ `
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.
Execute the orppm_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.
If you changed tablespace or user names, you will need to update the orppm_tables.sql script. You will need to update the PMDB_DAT1 tablespace name and the admuser, privuser, and pubuser names.
Do not use special characters in the database name, privileged user, public user, or PX reporting user name, for example: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~ `Do not use special characters in the database name, privileged user, or public user names, for example: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~ `
