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
CDEV> connect nightops/password@sid
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.
Any help or other suggestions are appreciated.