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>
To create users and tables:
- Log into the P6 EPPM database as SA user.
- Run the sspm_create_users.sql script.
Notes:
- Running the sspm_create_users.sql script creates the following user names: privuser, pubuser, and PxRptUser. If you have created other user names and wish to use those when running P6 EPPM database scripts, make sure to replace the private and public user names with your custom user names in all applicable scripts before running them.
- Do not use special characters in the database name, privileged user, public user, or PX reporting user name, for example: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~ `
- Run the sspm_tables.sql script in the database you created when you ran the sspm_init_db.sql script.
Notes:
- If you changed database or user names, you will need to update the sspm_tables.sql script. You will need to update the PMDB name and the privuser, pubuser, and pxrptuser names.