Re: Logon trigger not firing

Peter,

Thanks for the comment. I was doing a commit as soon as I logged in, and then I changed the trigger to do an "execute immediate 'commit';" right after the insert. Neither made any difference.

Lisa

Peter Sylvester wrote:

> Well, for one thing, I don't see this committed anywhere...
>
> --Peter
>
> Lisa McGrath wrote:
> > 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 McGrath
Lmcgrath_at_uwsa.edu    (608) 263-4535
Office of Information Services
University of Wisconsin System Administration
--