Creating Remaining P6 Professional Database Objects

The scripts in this task are located in:

Install scripts: \database\scripts\install\PPM_<release level>

Source scripts: \database\scripts\source\PPM_<release level>

To create remaining database objects:

Log on to the P6 Professional database as the SA user.
Go to \database\scripts\install\PPM_<release level> and run the ssppm_querylib.sql script.
Go to \database\scripts\install\PPM_<release level> and run the ssppm_ins_aux.sql script.
Go to \database\scripts\install\PPM_<release level> and run the ssppm_settings.sql script.
Notes:
- The ssppm_ins_aux.sql script has a grant that reads: GRANT SELECT ON PUBUSER TO PUBUSER. If you changed the default pubuser name, do not change the name of the PUBUSER table, only change the user name. For example: GRANT SELECT ON PUBUSER TO NEW_PUBUSER_USERNAME
- If you changed the default privuser and pubuser names, update the ssppm_ins_aux.sql script with your custom privuser and pubuser names.
- Do not use special characters in the database name, privileged user, or public user name, for example: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~ `
Go to \database\scripts\source\PPM_<release level> and run the ssppm_src.plb script.
Notes:
- If you changed the default privuser name, update the ssppm_src.plb script with your custom privuser name.
- Do not use special characters in the database name, privileged user, or public user name, for example: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~ `
Go to \database\scripts\install\PPM_<release level> and run the ssppm_database_version.sql script. If you used a non-default privuser name, you must do the following:
1. Log into the databaselogins.bat (on Windows) or databaselogins.sh (on Unix) database as privuser (use your custom privuser name if you created a custom user name and password).
2. Update the privuser name and password to match what you used when you created users in Creating Users and Tables.

Related Topics