Database Administration (MOSC)

MOSC Banner

What privileges are required to see all rows in V$CONTAINERS?

Hello,

I have tested this on Oracle versions 12.2 and 19c, so I do not believe this is a version specific question.

When I connect to the container (CDB$ROOT) as sys and run this SQL:

select * from v$containers;

Then I see a row for CDB$ROOT, PDB$SEED, and several pluggable databases.

Then, I create a common user with the DBA role, like this:

create user c##jdorlon identified by jdorlon container = all;

grant dba to c##jdorlon container = all; 

grant set container to c##jdorlon container = all;

Now, if I connect to CDB$ROOT as C##JDORLON and again run

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