Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Trigger "AFTER LOGON ON SCHEMA" never works.
mark sure the hidden parameter _SYSTEM_TRIG_ENABLED is not set to FALSE (see
MetaLink Note:68636.1 )
-- ---------------------------------------- Mark C. Stock www.enquery.com (888) 512-2048 "Lav Kovacic" <lako_at_inet.hr> wrote in message news:bnl7f6$r0j$2_at_newstree.wise.edt.ericsson.se...Received on Tue Oct 28 2003 - 08:57:28 CST
> I have created a trigger with the following script:
>
> CREATE OR REPLACE TRIGGER "LAV"."PROBA"
> AFTER LOGON ON SCHEMA
> BEGIN
>
> INSERT INTO aa_log values (
> 10000,
> 'Trigger',
> 1,
> 'AAA',
> 'BBB');
>
> COMMIT;
>
> END;
>
> User that creates the trigger has "CREATE TRIGGER" and
> "ADMINISTER DATABASE TRIGGER" privileges.
>
> The trigger is successfully compiled and enabled.
>
> The Insert command (from triggers body) was tested separately, and it
works.
>
> However, when the user performs logon, nothing is inserted into
> the table, so I conclude that the trigger is not fired.
> What should I do to make it work?
>
> Server: Solaris 9, Oracle 9i
> Client: Win2k, SP4
>
> Thanks in advance,
> Lav
>
>
>