To Show All User In Oracle Database

If we want to display all user in Oracle Database we can use the following command :

SQL> SELECT * FROM ALL_USERS;

USERNAME              USER_ID CREATED
--------------------- ------- ---------
XDB                        59 13-NOV-10
TESTING                    64 05-JAN-11
DODOL                      60 13-NOV-10
EXPORTADMIN                58 12-NOV-10
TEDY                       56 06-NOV-10
SCOTT                      54 30-JUN-05
MGMT_VIEW                  53 30-JUN-05
RMAN                       61 14-NOV-10
MDDATA                     50 30-JUN-05
SYSMAN                     51 30-JUN-05
MDSYS                      46 30-JUN-05
SI_INFORMTN_SCHEMA         45 30-JUN-05
ORDPLUGINS                 44 30-JUN-05
ORDSYS                     43 30-JUN-05
OLAPSYS                    47 30-JUN-05
ANONYMOUS                  39 30-JUN-05
CTXSYS                     36 30-JUN-05
EXFSYS                     34 30-JUN-05
WMSYS                      25 30-JUN-05
DBSNMP                     24 30-JUN-05
TSMSYS                     21 30-JUN-05
DMSYS                      35 30-JUN-05
DIP                        19 30-JUN-05
OUTLN                      11 30-JUN-05
SYSTEM                      5 30-JUN-05
SYS                         0 30-JUN-05

26 rows selected.

SQL>

Or this command :

SQL> SELECT USERNAME FROM DBA_USERS;

USERNAME
------------------------------
MGMT_VIEW
SYS
SYSTEM
DBSNMP
SYSMAN
EXPORTADMIN
TESTING
DODOL
TEDY
RMAN
OUTLN
MDSYS
ORDSYS
EXFSYS
DMSYS
WMSYS
CTXSYS
ANONYMOUS
ORDPLUGINS
SI_INFORMTN_SCHEMA
OLAPSYS
SCOTT
TSMSYS
MDDATA
DIP
XDB

26 rows selected.

SQL>

2 thoughts on “To Show All User In Oracle Database

  1. siang pak

    oh ya pak,jika ada rekan2 yg membutuhkan produk server yg berhubungan dengan oracle,silahkan menhubungi kami, kami menyediakan server sun,primepower dll semua eks.import dengan harga yg murah,trims

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.