Note: Oracle recommends that you use Microsoft SQL Server Management Studio to perform the following steps.
To create users and tables:
- Log into the P6 Professional database as SA user.
- Go to \database\scripts\install\PPM_<release level> and run the ssppm_create_users.sql script to create the privuser and pubuser users.
Notes:
- You must run the create script even if privuser and pubuser users already exist on the server; otherwise, later scripts will return errors. Note that if these users do already exist, the names and passwords will not be updated by the script.
- If you have created other user names and want to use those when running P6 Professional database scripts, 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, or public user name, for example: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~ `
- Go to \database\scripts\install\PPM_<release level> and run the ssppm_tables.sql script in the database you created when you ran the ssppm_init_db.sql.
Note: The ssppm_tables.sql script makes reference to the default user names privuser and pubuser. If you are not using the default usernames in your environment, open the script in a text editor and update the default user name references with your custom user names before executing the script.