Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Trigger "AFTER LOGON ON SCHEMA" never works.
shouldn't that read
AFTER LOGON <SCHEMANAME>.SCHEMA ?
-- Niall Litchfield Oracle DBA Audit Commission Uk "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 - 04:24:49 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
>
>
>