users on database-server

Posted in 2000

Andreas Lommel — Mon, 16 Oct 2000 13:43:57 GMT — source: Informix-list mailing list archive (1991-1998)

Hi there ! How can I see alls users (active and inactive) with their rights ?

↪ replying to Andreas Lommel

Sergey E. Volkov — Tue, 17 Oct 2000 15:17:32 +0400 — source: Informix-list mailing list archive (1991-1998)

All users: select * from sysusers All roles: select * from sysroleauth All active sessions: select * from sysmaster:syssessions Andreas Lommel <him_lommel@t-online.de> ''''' ' ''''''''':39d1ece0.22009618@news.btx.dtag.de... > Hi there ! How can I see alls users (active and inactive) with their > rights ? >