cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Oracle Database Users...

Former Member
0 Likes
4,022

HI,

How I can see the list of all Oracle Database user .... is there any way, plz lemme know.

thanks

View Entire Topic
Former Member
0 Likes

Hii

1. Login as oracle user on windows/Linux/UNIX and connect to sqlplus:

sqlplus /nolog

2. Login into Oracle database as sysdba

How to connect to oracle as sysdba

SQL> connect / as sysdba;

Connected.

SQL>SQL> select * from all_users;

It wil list all the users in Oracle database

Hope it helps

Rohit