on logon trigger
I have created a logon trigger to trace one particular user when he connects do DB. Here is the script.
This trigger is working if I am login with USER from the DB Server. But It is not working when the USER is connecting from application.
CREATE OR REPLACE TRIGGER ON_LOGON_USER
AFTER LOGON ON DATABASE
WHEN ( USER = 'USER' )
execute immediate 'alter session set tracefile_identifier="trace"';
execute immediate 'alter session set events ''10046 trace name context forever, level 12''';
WHEN OTHERS THEN
I am trying to understand what is going wrong. Any help is appreciated.
by the way, here is the environment.
Windowz 2003 SP2
Oracle 10G R2
Try hard to get what you like OR you will be forced to like what you get.