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

ORA-28001: the password has expired
ORA-00955: name is already used by an existing object
Check if any Oracle Data Files Needed for Recovery
How to Find / List Available Schema in Oracle
© 2018 ITsiti. All Rights Reserved
Powered by KEEM