Trigger Fails
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Trigger Fails

  1. #1
    Join Date
    Jan 2002
    Posts
    113

    Trigger Fails

    I am trying to create a trigger that will start sql trace when a certain user logs in. The trigger is created successfuly but the user is getting errors while logging in. This is what I get:


    CDEV> CREATE OR REPLACE TRIGGER LogonTrigger AFTER LOGON ON NIGHTOPS.schema
    2 BEGIN
    3 dbms_session.SET_sql_trace(TRUE);
    4 END;
    5 /

    Trigger created.

    CDEV> connect nightops/password@sid
    ERROR:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-01031: insufficient privileges
    ORA-06512: at "SYS.DBMS_SESSION", line 86
    ORA-06512: at line 2

    Warning: You are no longer connected to ORACLE.
    CDEV>

    Any help or other suggestions are appreciated.

    Arm yourself with knowledge

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    the trigger owner needs direct grant of ALTER SESSION privilege

  3. #3
    Join Date
    Jan 2002
    Posts
    113
    Thanks pando. Works great now!
    Arm yourself with knowledge

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