To create users and tables:
- Log into the P6 Professional database as a SYSTEM or other DBA privileged user.
- Go to \database\scripts\install\PPM_<release_level> and run the orppm_create_users.sql script.
Notes:
- Running the orppm_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 Professional 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 Professional database as admuser, or use your custom administrative user name if you created one.
- Go to \database\scripts\install\PPM_<release_level> and run the orppm_tables.sql script.
Notes:
- 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, or public user names, for example: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~ `