To upgrade the P6 EPPM Microsoft SQL Server Database:
Notes:
Notes:
SSPM_p70sp1.sql, if upgrading from P6 version 7.0, 7.0 service pack 1, or 7.0 service pack 2
SSPM_p70sp3.sql, if upgrading from P6 version 7.0 service pack 3
SSPM_p70sp5.sql, if upgrading from P6 version 7.0 service pack 5
SSPM_p80.sql, if upgrading from P6 version 8.0
SSPM_p81.sql, if upgrading from P6 version 8.1
SSPM_p81sp3.sql, if upgrading from P6 version 8.1 service pack 3
SSPM_p82.sql, if upgrading from P6 version 8.2
SSPM_p82sp1.sql, if upgrading from P6 version 8.2 service pack 1
SSPM_p82sp2.sql, if upgrading from P6 version 8.2 service pack 2
SSPM_p82sp2f10.sql, if upgrading from P6 version 8.2 service pack 2 Hotfix 10
SSPM_p83.sql, if upgrading from P6 version 8.3
SSPM_p832.sql, if upgrading from P6 version 8.3 service pack 2
SSPM_p833.sql, if upgrading from P6 version 8.3 service pack 3
SSPM_p834.sql, if upgrading from P6 version 8.3 service pack 4
SSPM_p835.sql, if upgrading from P6 versions 8.3 service pack 5
SSPM_P84.sql, if upgrading from P6 version 8.4
SSPM_p841.sql, if upgrading from P6 versions 8.4 patch set 1
SSPM_p843.sql, if upgrading from P6 versions 8.4 patch set 3
SSPM_P151.sql, if upgrading from P6 version 15.1
SSPM_P152.sql, if upgrading from P6 version 15 R2
SSPM_P161.sql, if upgrading from P6 version 16 R1
If you're using a version before SSPM_p70sp1.sql, go to \scripts\common and execute the ss_update_usereng.sql script to grant all users with P6 Professional module access rights to the Projects section in P6.
Note: Prior to P6 version 7.0, users with Project Management module access also had rights to the Projects section in P6 Web Access. For security reasons, beginning with P6 version 7.0, P6 Professional module access only grants rights to log into the P6 Professional module.
Note: If you changed the default user names, you must update the privuser, pubuser, and PxRptUser names in this script with your custom user names.
Caution: The sspm_synonyms.sql script contains a table called PUBUSER, do not replace it if you have to change the pubuser user name.
Note: If you changed the default user names, you must update the privuser, pubuser, and PxRptUser names in this script with your custom user names.
Notes:
Legal Notices
Copyright © 1999, 2016,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, September 23, 2016