Wednesday, October 15, 2008

Logon Trigger to trace a specific user

CREATE OR REPLACE TRIGGER trace_trigger AFTER LOGON ON DATABASE
WHEN (user='APEX_ADMINISTRATOR')
BEGIN
execute immediate 'alter session set sql_trace=true';
END;
/