| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Trigger not firing!!!!!!!!!!(URGENT)
Check this:
14:15:12 SQL> CREATE TABLE log_info (login_date DATE, ipadds VARCHAR2(20),username VARCHAR2(30));
Table created.
Elapsed: 00:00:01.10
14:15:17 SQL> grant select on log_info to test;
Grant succeeded.
Elapsed: 00:00:00.07
14:15:25 SQL> CREATE OR REPLACE TRIGGER logon_audit AFTER LOGON ON DATABASE 14:15:30 2 BEGIN 14:15:30 3 insert into sys.log_info
Trigger created.
Elapsed: 00:00:00.19
14:15:30 SQL> select * from sys.log_info;
no rows selected
Elapsed: 00:00:00.00
14:15:40 SQL> conn test/test
Connected.
14:15:44 SQL> select * from sys.log_info;
LOGIN_DAT IPADDS USERNAME
--------- -------------------- ------------------------------ 09-JUN-05 TEST
Elapsed: 00:00:00.00
14:15:47 SQL> conn test/test_at_dbarepo1
Connected.
14:15:53 SQL> select * from sys.log_info;
LOGIN_DAT IPADDS USERNAME
--------- -------------------- ------------------------------ 09-JUN-05 TEST 09-JUN-05 10.44.19.31 TEST
Elapsed: 00:00:00.01
14:15:55 SQL>
If get the IP if you use the listener.
Cheers
Dimitre Radoulov
ETNØTEAM
> Raj,
> The code for the trigger is :
> CREATE OR REPLACE TRIGGER INFO
> AFTER LOGON
> ON DATABASE
> begin
> insert into info
> values(ora_client_ip_address,to_char(sysdate,'dd-mm-yyyy:HH:MI:SS'),ora_login_user);
> end;
> And I test it by logging into the DB with another user also say a user
> called LOG but no record in the table. Moreover I tried the following sql
> on
> the prompt also:
> SELECT ORA_CLIENT_IP_ADDRESS FROM DUAL; -- no output
> But when I issued :
> SELECT ORA_LOGIN_USER FROM DUAL; -- gives me the current username logged
> in
> the DB
> Any idea?????
>
> On 6/9/05, rjamya <rjamya_at_gmail.com> wrote:
>>
>> show us the real code and don't log in as SYS to test.
>>
>> Raj
>>
>> On 6/9/05, Onkar N Tiwary <onkarnath.tiwary_at_gmail.com> wrote:
>> >
>> > Sorry David,
>> > Its a typo error...its not LOGOFF its LOGON... I checked it once again
>> > also.
>> > On 6/9/05, David Sharples <davidsharples_at_gmail.com> wrote:
>> > >
>> > > 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
>> > 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> > 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);
>> >
>> > >
>> >
>> >
>> >
>> > --
>> > 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
>> >
>>
>>
>>
>> --
>> ------------------------------
>> select standard_disclaimer from company_requirements where category =
>> 'MANDATORY';
>>
>
>
>
> --
> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 09 2005 - 08:22:38 CDT
 |
 |