Oracle Security in CDBs and PDBs - OCP: Oracle Database 12c Administrator Certified Professional - page 651

3 ORDER BY OBJECT_NAME;
USERNAME OWNER OBJECT_NAME ALL CONTAINER_
-------------------- -------- -------------------- --- ----------
GSMADMIN_INTERNAL SYS CDB_SERVICES Y
C##MY_DBA SYS CDB_USERS N CDB$ROOT
C##MY_DBA SYS CDB_USERS N PDB1
C##MY_DBA SYS CDB_USERS N LNE6
GSMADMIN_INTERNAL SYS GV_$ACTIVE_SERVICES Y
C##MY_DBA SYS V$SESSION N LNE6
C##MY_DBA SYS V$SESSION N PDB1
C##MY_DBA SYS V$SESSION N CDB$ROOT
APPQOSSYS SYS V_$WLM_PCMETRIC Y
SYSBACKUP Y
SYS Y
SYSTEM Y
DBSNMP Y
13 rows selected.
SQL>
Now that c##my_dba can see the contents of the cdb_users view, here's an example of
the truncated output:
SQL> SHOW USER
USER is "C##MY_DBA"
SQL> SHOW CON_NAME
CON_NAME
-------------------
CDB$ROOT
SQL> BREAK ON username
SQL> SELECT username, con_id
2 FROM cdb_users
3 ORDER BY username, con_id;
SQL> show user
USER is "SYS"
SQL> ALTER USER c##my_dba
2 SET CONTAINER_DATA = (cdb$root, pdb1, lne6)
3 FOR cdb_users CONTAINER = CURRENT;