How do i find out all the database users on informix..Like in oracle i can query the dba_users table to get the list of database users.

Is there any table where informix stores this info.

Hi,
Run the script in dbaccess

database sysmaster;
select
sysdatabases.name database,
syssessions.username,
syssessions.hostname,
syslocks.owner sid
from syslocks, sysdatabases , outer syssessions
where syslocks.rowidlk = sysdatabases.rowid
and syslocks.tabname = "sysdatabases"
and syslocks.owner = syssessions.sid
and sysdatabases.name = "stores" -- change to ur db name
order by 1;