SQL - how to find number of user in the database.

GeekInterview.com > Interview Questions > Oracle > SQL

Go To First | Previous Question | Next Question

SQL | Question 107 of 170

how to find number of user in the database.

Total Answers and Comments: 5

Last Update: September 25, 2007 Asked by: Debi Prasad Maharana

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

November 08, 2006 05:48:43

rameshr

RE: how to find number of user in the database.

hi....

select * from all_users;

....this will give all the users created

select count(*) from all_users;

....this will give u no of user

Is this answer useful? Yes | No

November 20, 2006 02:51:07

deepak sony

RE: how to find number of user in the database.

thanks for giving me answers.

Is this answer useful? Yes | No

November 20, 2006 05:47:56

aaa

RE: how to find number of user in the database.

all_users may not give you correct results... dba_users should be used

Is this answer useful? Yes | No

January 06, 2007 07:27:31

Kannan

RE: how to find number of user in the database.

Sybase:

sp_who will help to find the available users.....

select * from sysusers - it used to find the no.of users in ur DB

Is this answer useful? Yes | No

September 25, 2007 12:02:43

kowmudiswarna

Member Since: September 2007 Contribution: 21

RE: how to find number of user in the database.

select count(*) from all_users;

Is this answer useful? Yes | No