Oracle Database Users...

[Former Member]

HI,

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

thanks

[Former Member]

Hi Rhishibh,

You can find all database usernames using below qury.

select username from dba_users;

or

select * frrom dba_users;

Regards

Nick Loy

[Former Member]

Hai,

The following command will show you the users in database

SQL>select username from dba_users;

If you further information about the account status

SQL>desc dba_users;

SQL>select username,account_status from dba_users,

Thanks and Regards,

[Former Member]

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