Database Administration (MOSC)

MOSC Banner

How to grant PDB rights for CDB common users

edited Oct 18, 2018 8:17AM in Database Administration (MOSC) 2 commentsAnswered ✓

I'd like to create a CDB common user to monitor the tablespaces and datafiles in CDB and PDB. This user should not be DBA and have only the necessary rights to system views. But even if I grant the rights to V$ and CDB-Views with the option CONTAINER = ALL, the new user sees only information about the CDB tablespaces and datafiles and no PDB information, what is different from what the SYS-Users sees. What I tried is listed below (Database replies are in German but I think it's evident, what they mean). Database is 12.2 Standard Edition. Which rights

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