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

Nope.
Try it with a user that is not dba.

HTH
Dimitre

• Original Message ----- From: Onkar N Tiwary To: Radoulov, Dimitre ; oracle-l_at_freelists.org 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_at_gmail.com> 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_at_gmail.com > wrote:       Did you try it with a user that is not DBA?

      HTH       Dimitre

• Original Message ----- From: "Onkar N Tiwary" <onkarnath.tiwary_at_gmail.com> To: < oracle-l_at_freelists.org> 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_at_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_at_yahoo.com
> onkarnath.tiwary_at_gmail.com
>
> --
> http://www.freelists.org/webpage/oracle-l

    --
    Thanks & Regards,
    T. Onkar Nath
    Ph : +91-9826728111(Cell)

           to_onkar_at_yahoo.com
           onkarnath.tiwary_at_gmail.com

  --
  Thanks & Regards,
  T. Onkar Nath
  Ph : +91-9826728111(Cell)

         to_onkar_at_yahoo.com
         onkarnath.tiwary_at_gmail.com 

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