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