Re: Logon trigger not firing

"Lisa McGrath" <lmcgrath_at_uwsa.edu> wrote in message news:3DDD2F6D.413C7F36_at_uwsa.edu...
> 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
> --
>

Lisa,

Drop, disable or revoke the DBA role and try again. Please post results.

HTH,
Paul Received on Thu Nov 21 2002 - 17:13:18 CST