on ‎2009 Feb 20 9:24 AM
HI,
How I can see the list of all Oracle Database user .... is there any way, plz lemme know.
thanks
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 9 | |
| 6 | |
| 4 | |
| 4 | |
| 3 | |
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.