RE: NEWERA -- login name

} You can retrieve the database login name by executing sql form your } newera program: } } select user } from emp } where emp_id=1 } } (or in fact any from/where clause yielding exactly one row) } } ---------------------------------------------------------------------- } --- } Frido van Orden } FAA Partners BV } Planetenbaan 117 } 3606 AK Maarssen } The Netherlands } Phone: +31-346-587076 } Fax: +31-346-587086 } } Email: fridoo@faapartners.com } ---------------------------------------------------------------------- } --- } } -----Original Message----- } From: Mike Ripley [SMTP:mike.ripley@excelsys.co.uk] } Sent: Thursday, October 09, 1997 10:01 AM } To: informix-list@rmy.emory.edu } Subject: NEWERA -- login name } } As in most applications I need to restrict certain users to certain } functions and to this end I have set up the obligatory user name and } functions table. } I need to get the users log name into my newera program. } He already has to log in to the PC network and then has a seperate } password to log on to the server database through I-Net do I really } have } to get him to enter yet another username and password for my newera } programs } Being able to get the PC network log name would be nice! } Thanks } -- } Mike Ripley