Creating Users and Tables for Microsoft SQL Server

Previous TopicNext TopicContents

Note: Oracle recommends that you use Microsoft SQL Server Management Studio to perform the following steps.

The scripts in this task are located in:

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

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

To create users and tables:

  1. Log into the P6 EPPM database as SA user.
  2. Execute the sspm_create_users.sql script.Execute the ssppm_create_users.sql script.

    Notes:

  3. Execute the sspm_tables.sql script in the database you created when you ran the sspm_init_db.sql script.Execute the ssppm_tables.sql script in the database you created when you ran the ssppm_init_db.sql

    Notes:

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

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

Creating Remaining Database Objects for Microsoft SQL Server



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

Last Published Thursday, February 04, 2016

PDF Library