Re: Enabling the SQL Trace from a logon trigger

Does your user have the 'alter session' privilege ?

    grant alter session to myuser;

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

lolocyrano_at_my-deja.com wrote in message <7r5ri9$gag$1_at_nnrp1.deja.com>...
>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
Received on Wed Sep 08 1999 - 10:01:10 CDT