My Oracle Support Banner

Select Privileges To XDB$CHECKOUTS And XDB$PATH_INDEX_PARAMS Missing From SELECT_CATALOG_ROLE After Upgrade (Doc ID 2352885.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Standard Edition - Version 12.1.0.2 and later
Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

After upgrading from 12.1.0.1 to 12.1.0.2, some object privileges are missing for XDB tables XDB$CHECKOUTS and XDB$PATH_INDEX_PARAMS.



 Before upgrade script:
 ------------------------------------------------------------------
 select PRIVILEGE, table_name, owner,grantee from dba_tab_privs
 where table_name in ('XDB$CHECKOUTS','XDB$PATH_INDEX_PARAMS');

 PRIVILEGE            TABLE_NAME            OWNER GRANTEE
 -------------------- --------------------- ----- ----------
 ALTER                XDB$CHECKOUTS         XDB   DBA
 DELETE               XDB$CHECKOUTS         XDB   DBA
 INSERT               XDB$CHECKOUTS         XDB   DBA
 SELECT               XDB$CHECKOUTS         XDB   DBA
 UPDATE               XDB$CHECKOUTS         XDB   DBA
 ON COMMIT REFRESH    XDB$CHECKOUTS         XDB   DBA
 QUERY REWRITE        XDB$CHECKOUTS         XDB   DBA
 DEBUG                XDB$CHECKOUTS         XDB   DBA
 FLASHBACK            XDB$CHECKOUTS         XDB   DBA
 ALTER                XDB$CHECKOUTS         XDB   SYSTEM
 DELETE               XDB$CHECKOUTS         XDB   SYSTEM
 INDEX                XDB$CHECKOUTS         XDB   SYSTEM
 INSERT               XDB$CHECKOUTS         XDB   SYSTEM
 SELECT               XDB$CHECKOUTS         XDB   SYSTEM
 UPDATE               XDB$CHECKOUTS         XDB   SYSTEM
 REFERENCES           XDB$CHECKOUTS         XDB   SYSTEM
 ON COMMIT REFRESH    XDB$CHECKOUTS         XDB   SYSTEM
 QUERY REWRITE        XDB$CHECKOUTS         XDB   SYSTEM
 DEBUG                XDB$CHECKOUTS         XDB   SYSTEM
 FLASHBACK            XDB$CHECKOUTS         XDB   SYSTEM
 SELECT               XDB$CHECKOUTS         XDB   SELECT_CATALOG_ROLE
 SELECT               XDB$PATH_INDEX_PARAMS XDB   SELECT_CATALOG_ROLE
 ------------------------------------------------------------------



 After upgrade script:
 ------------------------------------------------------------------
 select PRIVILEGE, table_name, owner,grantee from dba_tab_privs
 where table_name in ('XDB$CHECKOUTS','XDB$PATH_INDEX_PARAMS');

 PRIVILEGE            TABLE_NAME            OWNER GRANTEE
 -------------------- --------------------- ----- ----------
 READ                 XDB$CHECKOUTS         XDB   DBA
 READ                 XDB$CHECKOUTS         XDB   SYSTEM
 ------------------------------------------------------------------

 

Changes

12.1.0.1 database has been upgraded to 12.1.0.2.

You notice the privileges of XDB$PATH_INDEX_PARAMS and XDB$CHECKOUTS tables are changed after running "catctl.pl catupgrd.sql".

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.