How to find out user account and non-user account details in ASE

[former_member747366]

How to find out user account and non-user account details in ASE

is there any way to find out

[jong-un_seo]

Hi Srikanth,

I'm not sure I understood your question correctly.
But if you want to know which one is a user account or not in sysusers table, user account is that suid is greater than 0 in it.

select * from sysusers where suid > 0
go

select suid, suser_name(suid), uid, user_name(uid), name from sysusers where suid > 0
go

OR

sp_helpuser
go

Best regards,
Jongun