Re: Username for this session

Posted in 1997

"Wanda Beck" — 7 Aug 1997 11:18:06 -0400 — source: Informix-list mailing list archive (1991-1998)

Hi, Vinitha! With Online Dynamic Server 7.21, this works for me: select username into uname_var from sysmaster:syssessions where sid = dbinfo( 'sessionid' ) or select uid into uid_var from sysmaster:syssessions where sid = dbinfo( 'sessionid' ) I don't know if OWS 7.12 has the same capabilities, but try it. TTFN! -- Wanda Beck Voice: (303) 413-4236 Sybase, Inc. Fax: (303) 413-4025 3665 Discovery Dr. email: wbeck@sybase.com Boulder, CO 80303 bfldc2@plutonium.bflsl.soft.net (Vinitha) on 08/07/97 06:17:03 AM To: informix-list@rmy.emory.edu @ smtp, johnl@informix.com @ smtp cc: (bcc: Wanda Beck/SYBASE) Subject: Username for this session Hello, I am involved in a LiveWirePro application with OWS 7.12TC5. In a particular Insert statement, one of the fields is the name of the user who is currently performing the Insert operation. Is there a variable in Informix like Oracle has "userid" which holds this value and can be used directly in the Insert ? If yes, what is the variable ? If no, how else could I insert the name of the current session userid into my table ? Thanks in advance, Vinitha