Re: how to check user login to which database??? (urgent!!!)

This will work. 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 order by 1; ----- Original Message ----- From: "aaa" <aaa_member@newsguy.com> Sent: Mon, September 28, 2009 7:53 Subject:how to check user login to which database??? (urgent!!!) we have Informix database on Redhat LINUX server. Due to primary DBA off, I need temporary take care the Database. My questions are: 1. how to check which user login to database? (on ORACLE we can use select username from v$session) 2. does there has way check user login to which database on LINUX command? ("onstat -u" only show user login, but did not say which database) Thanks. _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list ----- End of original message -----