Database Administration (MOSC)

MOSC Banner

Restrict CDB_* views access to all users created in a PDB

edited May 5, 2020 5:01AM in Database Administration (MOSC) 3 commentsAnswered

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center