Re: Logon trigger not firing

On Thu, 21 Nov 2002 13:08:58 -0600, Lisa McGrath <lmcgrath_at_uwsa.edu> wrote:

I can't remember the execat init.ora parm you add during maintenance. Could you have done something like _system_trigger_enabled = false to install 8.1.7.3 patch and forgot to take it out?

>I'm trying to create a simple logon trigger but it never seems to fire.
>We're running Oracle 8.1.7.3.0 on a UNIX AIX system.
>
>The trigger I'm trying to create is:
>
>CREATE OR REPLACE TRIGGER set_id_on_logon
>AFTER logon ON DATABASE
>BEGIN
> insert into uwsias.rls_trigger_test
> values (user, 'Executing logon trigger',sysdate);
>END;
>
>I have already created the uwsias.rls_trigger_test table and have
>granted all on the table to PUBLIC and directly to SYS, SYSTEM, and
>CSILVA (a test id). I've created this trigger both as SYS and as
>SYSTEM, and have created it both as ON DATABASE trigger and ON
>CSILVA.SCHEMA trigger. Nothing seems to work.
>
>The trigger created ok, is valid and enabled. When I logon as CSILVA I
>connect ok - no 'insufficient privileges' or other error message, but
>no record is inserted either. Am I missing a step? Does the database
>need to be restarted before a logon trigger will take effect? Some
>parameter that needs to be set?
>
>Thanks for any help.
>
>Lisa
>--
>Lisa McGrath
>Lmcgrath_at_uwsa.edu (608) 263-4535
>Office of Information Services
>University of Wisconsin System Administration
>--
>
>
Received on Sun Mar 09 2003 - 19:02:07 CST