How to find out list of users currently logged in
Posted in the Sybase Forum
#1 Apr 8, 2009
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
#2 Nov 11, 2010
Use 'sp_who' to see the users logged on in DB.
#3 Mar 28, 2011
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.
#4 Apr 4, 2013
Hey how can I view users recently logged on to the server
#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???
Add your comments below
|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|
|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|
Find what you want!
Search Sybase Forum Now
Copyright © 2017 Topix LLC