Can you get other parameters in this type of trigger i.e. OSUSER, MACHINE_NAME, for auditing purposes, I am look through the DBMS_*** packages for this info. Thanks=20 Rick Weiss Oracle Database Administrator Montana Department of Labor & Industry Centralized Services Division Technical Services Bureau 1327 Lockey P.O. Box 1728 Helena, Montana 59624-1728 (406) 444-9628 rweiss@xxxxxx -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of David Sharples Sent: Thursday, June 09, 2005 4:52 AM To: onkarnath.tiwary@xxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: Trigger not firing!!!!!!!!!!(URGENT) You say its a logon trigger, but it it written as a LOGOFF - try logging off first On 6/9/05, Onkar N Tiwary <onkarnath.tiwary@xxxxxxxxx> wrote: > hi all, > I have created one trigger on LOGON event which is storing the ip of=20 > the machine making the connection,current date n time and oracle=20 > username in =3D a > table with the following structure: > 16:15:31 SQL log@TEST35> > CREATE OR REPLACE TRIGGER INFO BEFORE=20 > LOGOFF ON DATABASE begin insert into info=20 > values(ora_client_ip_address,to_char(sysdate,'dd-mm-yyyy:HH:MI:SS'),or > a_l=3D ogin_user); -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l