Restrict CDB_* views access to all users created in a PDB
Dear Team,
We are working on Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production.
When I run the below query, I get the following details.
select sys_context('USERENV','CON_NAME') CON_NAME,
sys_context('USERENV','CON_ID') CON_ID,
sys_context('USERENV','DB_NAME') DB_NAME,
decode(sys_context('USERENV','CON_ID'),1,'CDB','PDB') TYPE
from DUAL;
Output:
CON_NAME: PDWH
CON_ID: 0 (ZERO)
DB_NAME: PDWH
TYPE: PDB
I've created one new schemauser named as 'SACAPP'. I've then created some DB objects like Tables and views on the schema 'SACAPP'. I am trying to connect to this DB schema from my external application SAP Analytics Cloud (SAC) platform. When I try this, I am getting timeout error. When I check the logfile, I see the metadata import is taking longer time and can see the metadata objects being selected from SYS, XDB, WMSYS and CDB_* views along with my schema metadata.