Question Re: Oracle Database Users... in Technology Q&A

Oracle Database Users...

Former Member — Fri, 20 Feb 2009 09:24:32 GMT

HI,

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

thanks

Former Member — Fri, 20 Feb 2009 09:29:29 GMT

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

Former Member — Fri, 20 Feb 2009 09:55:28 GMT

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 — Sun, 22 Feb 2009 15:10:17 GMT

Hi Rhishibh,

You can find all database usernames using below qury.

select username from dba_users;

select * frrom dba_users;

Regards

Nick Loy