Enabling the SQL Trace from a logon trigger

I create the following trigger in the schema MyUser under the user MyUser:

create trigger tr_logon after logon on schema begin
  execute immediate 'alter session set sql_trace true'; end;

It compiles.
Then, when I logon using MyUser, I get the following message:

ORA-00604: error occurred at recursive SQL level 1
ORA-01031: insufficient privileges
ORA-06512: at line 2

Can anyone help???

If I create the trigger under the user SYS as follows:

create trigger tr_logon after logon on MyUser.schema begin
  execute immediate 'alter session set sql_trace true'; end;

then, everything works. But I wish I didn't need to use SYS!!

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Sep 08 1999 - 09:24:24 CDT