Skip to content

Instantly share code, notes, and snippets.

@DarkAngelStrike
Last active May 8, 2017 03:29
Show Gist options
  • Save DarkAngelStrike/edd232121ea87fd1074376b8e1e233ea to your computer and use it in GitHub Desktop.
Save DarkAngelStrike/edd232121ea87fd1074376b8e1e233ea to your computer and use it in GitHub Desktop.
SYS@CDB> alter session set container = CDB$ROOT;
Session altered.
SYS@CDB> show con_name
CON_NAME
------------------------------
CDB$ROOT
SYS@CDB> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
4 PDB READ WRITE NO
SYS@CDB> col username for a30
SYS@CDB> select username, common, con_id from cdb_users where username like 'APEX%';
USERNAME COMMON CON_ID
------------------------------ ------ ----------
APEX_LISTENER NO 4
APEX_PUBLIC_USER YES 4
APEX_REST_PUBLIC_USER NO 4
APEX_050000 YES 4
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment