List / Find Users in Oracle



Share this article :

1. Login to your Oracle SQL and execute below command. This will list all users from the Oracle.

SQL> select USERNAME from dba_users;

USERNAME
------------------------------
SAPSR3
SYS
OPS$SIDADM
OPS$ORASID
ITSITI
SYSTEM

6 rows selected.

2. For a specified users, execute below command.

SQL> select USERNAME from dba_users where USERNAME='SYSTEM';

USERNAME
------------------------------
SYSTEM

Related posts

Oracle NOARCHIVELOG & ARCHIVELOG Mode
Oracle Environment Variables
Get the Oracle Hostname & IP Address
Determine the Oracle Database Version
© 2017 ITsiti. All Rights Reserved
Powered by KEEM