Execute the sspm_create_users.sql script.Execute the ssppm_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.Running the ssppm_create_users.sql script creates the following user names: privuser and pubuser. 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: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~ `Do not use special characters in the database name, privileged user, or public user name, for example: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~ `
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:
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.
If you changed database or user names, you will need to update the ssppm_tables.sql script. You will need to update the PMDB name and the privuser and pubuser names.