How to List all Users Account in Oracle Database

In Oracle sometimes it is necessary to view the list of all users for retrieving some attributes or settings of passwords using sql. So here you will get all the methods to Show all users in Oracle Database using SQL and MySQL.

To List current user in SQL:

Method 1:
SQL>SHOW USER

Method2:
SQL>SELECT USERNAME FROM DBA_USERS;


To describe users:
SQL>DESC ALL_USERS;

To Show All Users:
SQL>SELECT * FROM ALL_USERS;

How to show the list of MySQL users and their privileges
mysql> select * from mysql.user;

To describe MySQL users:
MYSQL> desc mysql.user;