Database Reference
In-Depth Information
User altered.
SQL> SELECT USERNAME, OWNER, OBJECT_NAME, ALL_CONTAINERS, CONTAINER_NAME
2 FROM CDB_CONTAINER_DATA
3 ORDER BY OBJECT_NAME;
USERNAME OWNER OBJECT_NAME A CONTAINER_NAME
-------------------- -------- -------------------- - --------------------
GSMADMIN_INTERNAL SYS CDB_SERVICES Y
C##MY_DBA SYS CDB_USERS N PDB1
C##MY_DBA SYS CDB_USERS N CDB$ROOT
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 CDB$ROOT
APPQOSSYS SYS V_$WLM_PCMETRIC Y
SYSTEM Y
DBSNMP Y
SYS Y
USERNAME OWNER OBJECT_NAME A CONTAINER_NAME
-------------------- -------- -------------------- - --------------------
SYSBACKUP Y
12 rows selected.
SQL> connect c##my_dba/secret
Connected.
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
4 /
Search WWH ::
Custom Search