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 =3D USERENV('SESSIONID');

Tom

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Weiss, Rick Sent: Thursday, June 09, 2005 2:55 PM
To: Oracle-L (E-mail)
Subject: 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=3D20

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=3D20
> the machine making the connection,current date n time and oracle=3D20
> username in =3D3D

a
> table with the following structure:
> 16:15:31 SQL log_at_TEST35> > CREATE OR REPLACE TRIGGER INFO BEFORE=3D20
> LOGOFF ON DATABASE begin insert into info=3D20
> values(ora_client_ip_address,to_char(sysdate,'dd-mm-yyyy:HH:MI:SS'),or
> a_l=3D3D

ogin_user);

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

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