Logon trigger not firing

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 Thu Nov 21 2002 - 13:08:58 CST