hi,

I have created a logon trigger to trace one particular user when he connects do DB. Here is the script.

CREATE OR REPLACE TRIGGER ON_LOGON_USER
AFTER LOGON ON DATABASE
WHEN ( USER = 'USER' )
BEGIN
execute immediate 'alter session set tracefile_identifier="trace"';
execute immediate 'alter session set events ''10046 trace name context forever, level 12''';
EXCEPTION
WHEN OTHERS THEN
NULL;
END;
/
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.

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
Application: Remedy

Thanks,