I'm using Oracle Database 12C, and I've created a common user.
If I connect using my user, and query V$CONTAIONERS, I only get a single result for CDB$ROOT. However, if I connect as system and perform the same query, I see five records, CDB$ROOT, PDB$SEED and three pluggable databases.
I'm trying to understand why there's this difference. From what I've been able to find looking about on the internet, the visibility of data in that view should be controlled by whether or not the user is a common user (it is), and the current container. By running "SHOW CON_NAME", I can see that the current container is CDB$ROOT in both cases.
What else could be the cause of this difference? Is there a permission or setting I need to change that will allow my user to see all the containers?