Common scripts: \database\scripts\common\PM_<release_level>
To create remaining database objects:
Log on to the P6 EPPM database as SA user.
Execute the ss_set_currency.sql common script.
Execute the sspm_querylib.sql install script.
Execute the sspm_ins_aux.sql install script.
Notes:
The sspm_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, you must update the sspm_ins_aux.sql script with your custom privuser and pubuser names.
Do not use special characters in the database name, privileged user, public user, or PX reporting user name, for example: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~ `
Execute the sspm_synonyms.sql source script.
Execute the sspm_src.plb source script.
Notes:
If you changed the default privuser name, you must update the sspm_src.plb script with your custom privuser name.
Do not use special characters in the database name, privileged user, public user, or PX reporting user name, for example: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~ `
Execute the sspm_init_bgjobs.sql script.
Execute the sspm_settings.sql install script.
Execute the sspm_database_version.sql install script.
Log into the SQL Server Management Studio as pxrptuser, or use your custom PX reporting user name if you created one, and then execute the sspm_px_rpt_src.sql source script.
Notes:
If you changed the default pxrptuser name, you must update the sspm_px_rpt_src.sql script with your custom pxrptuser name.
Do not use special characters in the database name, privileged user, public user, or PX reporting user name, for example: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~ `
If you used a non-default privuser name, you must do the following:
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).