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]

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,