Re: Trigger not firing!!!!!!!!!!(URGENT)
- From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
- To: "Onkar N Tiwary" <onkarnath.tiwary@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 9 Jun 2005 13:19:48 +0200
Nope.
Try it with a user that is not dba.
HTH
Dimitre
----- Original Message -----
From: Onkar N Tiwary
To: Radoulov, Dimitre ; oracle-l@xxxxxxxxxxxxx
Sent: Thursday, June 09, 2005 1:00 PM
Subject: Re: Trigger not firing!!!!!!!!!!(URGENT)
sorry ,
I just forgot to mention one thing that this trigger is owned by the user SYS
but since its a database level trigger so I don think it could be a problem..
Could it be???
On 6/9/05, Onkar N Tiwary <onkarnath.tiwary@xxxxxxxxx> wrote:
Yup, but since the table was owned by the user SYS so I granted INSERT
privilege to the that user also but then also no luck....
On 6/9/05, Radoulov, Dimitre <cichomitiko@xxxxxxxxx > wrote:
Did you try it with a user that is not DBA?
HTH
Dimitre
----- Original Message -----
From: "Onkar N Tiwary" <onkarnath.tiwary@xxxxxxxxx>
To: < oracle-l@xxxxxxxxxxxxx>
Sent: Thursday, June 09, 2005 12:46 PM
Subject: Trigger not firing!!!!!!!!!!(URGENT)
> hi all,
> I have created one trigger on LOGON event which is storing the ip of
the
> machine making the connection,current date n time and oracle username
in a
> table with the following structure:
> 16:15:31 SQL log@TEST35> desc info
> Name Null? Type
> ----------------------------------------- --------
> ----------------------------
> IP NOT NULL VARCHAR2(40)
> LOG_DATE NOT NULL DATE
> ORAUSER NOT NULL VARCHAR2(20)
> , but its not working. Dont know where is the error????
> Can anyone plz. suggest me how to do this?????
> CREATE OR REPLACE TRIGGER INFO
> BEFORE LOGOFF
> ON DATABASE
> begin
> insert into info
>
values(ora_client_ip_address,to_char(sysdate,'dd-mm-yyyy:HH:MI:SS'),ora_login_user);
>
> end;
>
> --
> Thanks & Regards,
> T. Onkar Nath
> Ph : +91-9826728111(Cell)
> to_onkar@xxxxxxxxx
> onkarnath.tiwary@xxxxxxxxx
>
> --
> //www.freelists.org/webpage/oracle-l
--
Thanks & Regards,
T. Onkar Nath
Ph : +91-9826728111(Cell)
to_onkar@xxxxxxxxx
onkarnath.tiwary@xxxxxxxxx
--
Thanks & Regards,
T. Onkar Nath
Ph : +91-9826728111(Cell)
to_onkar@xxxxxxxxx
onkarnath.tiwary@xxxxxxxxx
--
//www.freelists.org/webpage/oracle-l
Other related posts:
