RE: Trigger not firing!!!!!!!!!!(URGENT)
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <rweiss@xxxxxx>, "Oracle-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 9 Jun 2005 15:02:36 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@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=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@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);
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
