DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: logoff trigger does n't works

  1. #1
    Join Date
    Aug 2007
    Posts
    5

    logoff trigger does n't works

    Hi
    I created one logoff trigger . but tat does n't work properly
    but log on trigger works properly. wat's the problem

    I'm using oracle 9i with unix environment

    coding
    *********
    create or replace trigger logoff_trig
    before logoff on schema
    begin

    insert into logon_trig values (user,sysdate,'logging off');

    end;
    /
    ~



    SQL> @logoff.sql

    Trigger created.

    SQL> select*from logon_trig;

    no rows selected

    SQL> exit
    Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.1.0 - Production
    /wd/arul>s

    SQL*Plus: Release 9.2.0.1.0 - Production on Fri Sep 7 11:22:09 2007

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.1.0 - Production

    SQL> select*from logon_trig;

    no rows selected

  2. #2
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    First of all : ** what ** database user are you using ??? As we know (showed in http://asktom.oracle.com/pls/asktom/...:1844531724208 to db version 8i, but iirc valid to 9i also), triggers DO NOT FIRE to database users with DBA role... Another point, how is your _system_trig_enabled parameters ???

    Regards,

    Chiappa

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width