RE: Trigger not firing!!!!!!!!!!(URGENT)

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_at_mt.gov

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David Sharples Sent: Thursday, June 09, 2005 4:52 AM
To: onkarnath.tiwary_at_gmail.com
Cc: oracle-l_at_freelists.org
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_at_gmail.com> 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_at_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);

--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l