Identifying number of account logins on Sybase
If you quickly need to see how many logins there are for each account in sybase, you can use this query:
select dbname=db_name(dbid),login=suser_name(suid), #connections=count(suid) from master..sysprocesses --where suser_name(suid) like '%dblogin%' group by dbid, suid order by count(suid)
