when loggined as SYSTEM,how to display all the users of database using sql query

Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

when loggined as SYSTEM,how to display all the users of database using sql query?

Question Posted / saiprasannach89

2 Answers
5087 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

when loggined as SYSTEM,how to display all the users of database using sql query?..

Answer / phan wai keong

select * from dba_users;

Is This Answer Correct ?

6 Yes

0 No

when loggined as SYSTEM,how to display all the users of database using sql query?..

Answer / pradeep

select * from all_users;

Is This Answer Correct ?

2 Yes

0 No

Post New Answer

More Oracle General Interview Questions

What is difference between sid and service name in oracle?

Explain view?

What is a user role in oracle?

What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

What are the different approaches used by Optimizer in choosing an execution plan ?

How to use subqueries with the exists operator in oracle?

What is the difference between post-database commit and post-form commit?

what is the use of composite key constraint?

Difference between join and a subquery?

8 Answers Base Automation, NMDC,

how to see the data (in unix) using dataset in datastage?

1 Answers iGate,

What are the different editions of oracle?

What are privileges and grants?

For more Oracle General Interview Questions Click Here

Categories

Oracle General (1803)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)
Oracle Security (38)
Oracle Forms Reports (510)
Oracle Data Integrator (ODI) (120)
Oracle ETL (15)
Oracle RAC (93)
Oracle D2K (72)
Oracle AllOther (241)