Select Privileges To XDB$CHECKOUTS And XDB$PATH_INDEX_PARAMS Missing From SELECT_CATALOG_ROLE After Upgrade
(Doc ID 2352885.1)
Last updated on NOVEMBER 21, 2019
Applies to:
Oracle Database Cloud Service - Version N/A and laterOracle Database - Standard Edition - Version 12.1.0.2 and later
Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A 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! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |