How to find out list of users current...

How to find out list of users currently logged in

Posted in the Sybase Forum

Sudhir

Naperville, IL

#1 Apr 8, 2009
Hi all,

I want to find out how many users are connected to the Sybase database currently.
'select suser_name()' gives me the info of the user currently logged in.

I am logged into the Sybase using iSql

~thanks
Sudhir
Sukhvinder

Mumbai, India

#2 Nov 11, 2010
Use 'sp_who' to see the users logged on in DB.
Mahesh Khadse

New York, NY

#3 Mar 28, 2011
Hi,

Try the system store procedure sp_who.

Whenever any users login to any database, the login information has tracked under the SysProcesses System Table. The sp_who system stored procedure gets the information from here.

Best Regards,
Mahesh Khadse
ajay kapoor

Charleston, WV

#4 Apr 4, 2013
Mahesh Khadse wrote:
Hi,
Try the system store procedure sp_who.
Whenever any users login to any database, the login information has tracked under the SysProcesses System Table. The sp_who system stored procedure gets the information from here.
Best Regards,
Mahesh Khadse
Hey how can I view users recently logged on to the server
selvackp

Coimbatore, India

#5 Jun 6, 2013
"select suser_name()" correctly working but i need to find all users of in current database??any one help me to find???

Tell me when this thread is updated:

Subscribe Now Add to my Tracker

Add your comments below

Characters left: 4000

Please note by submitting this form you acknowledge that you have read the Terms of Service and the comment you are posting is in compliance with such terms. Be polite. Inappropriate posts may be removed by the moderator. Send us your feedback.

Sybase Discussions

Title Updated Last By Comments
migration from Sybase to PostgresSQL database (Aug '14) Aug '14 Gaurav Bajpai 1
Sybase Jobs Openings in Mumbai (Jan '14) Jan '14 Mumbai Jobs 1
News New BlackBerry leader could see big returns if ... (Nov '13) Nov '13 FREE BLACKBERRY U... 1
Sybase - disk usage exceeds maximum storage limit (Aug '13) Aug '13 bill_n 1
Materialized view in sybase ASE15.0.3 (Jun '13) Jun '13 jashmi 1
sybase ase installers (Aug '11) Aug '11 jsalazar 1
Error in Using XMLtable() in ASE 15.0 (Jul '11) Jul '11 siddharth 1
More from around the web