6.2 Upgrade Scripts Change Resource Access Rights When Updating a Previous Version Database. (Doc ID 911885.1)

Last updated on JULY 24, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 6.1 and later
All Platforms

Symptoms

6.2 Upgrade Scripts changes resource access rights when updating a previous version database.

The 6.2 Upgrade script contains a query that updates and grants full resource access rights to all users:

--METADATA  TYPE:ADHOC_SQL
update users set ALL_RSRC_ACCESS_FLAG = 'Y'
/

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms