For much of that kinda stuff in 9i, you can try the ORA_ public synonyms (used as a function) like ORA_CLIENT_IP_ADDRESS or the SYS_CONTEXT function like SYS_CONTEXT('USERENV','OS_USER'). I would think these would probably be easier than spinning through v$session and probably more resistant to DB version changes. Enjoy! Rich -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mercadante, Thomas F (LABOR) Sent: Thursday, June 09, 2005 2:03 PM To: rweiss@xxxxxx; Oracle-L (E-mail) Subject: RE: Trigger not firing!!!!!!!!!!(URGENT) Rick, You can always query from v$session to get the other stuff. I use the following in my login trigger and store the results in a login table. SELECT UPPER(program) program, username, osuser, terminal, sys_context('USERENV','IP_ADDRESS') ip_addr FROM V$SESSION WHERE AUDSID =3D3D USERENV('SESSIONID'); Tom -- //www.freelists.org/webpage/oracle-l