Logon Trigger question

[jlakhani]

I used this trigger in 8i to do some tracing on a unix db and it has wroked but for some reason in 9i it doesnt work.

I wanted to trace a specific user's whose session id I cannot figure out due to to the fact that it the process connects and disconnects often..

any clues?

CREATE OR REPLACE TRIGGER LOG_TRIGGER AFTER
LOGON ON DATABASE begin
if user = 'OPS$KFOO' then
execute immediate 'alter session set sql_Trace=true';
end if;
end;