Creating Remaining Database Objects for Microsoft SQL Server

The scripts in this task are located in:

Install scripts: \database\scripts\install\PM_<release_level>

Source scripts: \database\scripts\source\PM_<release_level>

Common scripts: \database\scripts\common\PM_<release_level>

To create remaining database objects:

Log on to the P6 EPPM database as SA user.
1. Run the ss_set_currency.sql common script.
2. Run the sspm_querylib.sql install script.
3. Run 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: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~ `
4. Run the sspm_synonyms.sql source script.
5. Run the sspm_type_synonym.sql install script.
6. Run 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: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~ `
7. Run the sspm_init_bgjobs.sql script.
8. Run the sspm_settings.sql install script.
9. Run 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 run 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:
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 for Microsoft SQL Server.

Related Topics