rameshr

• Nov 8th, 2006

 

hi....

select * from all_users;

....this will give all the users created

select count(*) from all_users;

....this will give u no of user

deepak sony

• Nov 20th, 2006

 

thanks for giving me answers.

aaa

• Nov 20th, 2006

 

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

Kannan

• Jan 6th, 2007

 

Sybase:

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

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

kowmudiswarna

 Profile Answers by kowmudiswarna Questions by kowmudiswarna

• Sep 25th, 2007

 

select count(*) from all_users;