Creating Remaining Database Objects for Microsoft SQL Server

Previous TopicNext TopicContents

The scripts in this task are located in:

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

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

To create remaining database objects:

  1. Log on to the P6 EPPM database as SA user.
  2. Execute the sspm_querylib.sql install script.
  3. Execute the sspm_ins_aux.sql install script.
  4. Execute the sspm_settings.sql install script.

    Notes:

  5. Execute the sspm_src.plb source script.

    Notes:

  6. Execute the sspm_database_version.sql install script.
  7. Execute the sspm_init_bgjobs.sql script.
  8. Log into the SQL Server Management Studio as pxrptuser, or use your custom PX reporting user name if you created one.
  9. Execute the sspm_px_rpt_src.sql source script.

    Notes:

  10. 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

Creating the P6 EPPM Database Structure for Microsoft SQL Server

Copying the Script Files to a Local Drive for Microsoft SQL Server

Creating the Database for Microsoft SQL Server

Creating Users and Tables for Microsoft SQL Server

Installing Sample Data and Creating Your P6 Admin Superuser Password for Microsoft SQL Server



Legal Notices
Copyright © 1999, 2015, Oracle and/or its affiliates. All rights reserved.

Last Published Wednesday, July 29, 2015

PDF Library