How to find the users list in oracle 11g db?

sql oracle11g
Arun Blr picture Arun Blr · Mar 17, 2014 · Viewed 415.4k times · Source

How to find out the users list, which is all created in the oracle 11g database. Is there any command to find out the users list which we can execute from the Command line interface!

Answer

René Nyffenegger picture René Nyffenegger · Mar 17, 2014

I am not sure what you understand by "execute from the Command line interface", but you're probably looking after the following select statement:

select * from dba_users;

or

select username from dba_users;

Related questions

How do I do top 1 in Oracle?

How do I do the following? select top 1 Fname from MyTbl In Oracle 11g?

Read More
Left Outer Join using + sign in Oracle 11g

Can any one tell me whether below 2 queries are an example of Left Outer Join or Right Outer Join?? Table Part: Name Null? Type PART_ID NOT NULL VARCHAR2(4) SUPPLIER_ID VARCHAR2(4) PART_ID SUPPLIER_ID P1 S1 P2 S2 …

Read More
Display names of all constraints for a table in Oracle SQL

I have defined a name for each of the constraint for the multiple tables that I have created in Oracle SQL. The problem is that to drop a constraint for the column of a particular table I need to know …

Read More