Re: "alter session set sql_trace" Privilege

klabu wrote:
> I can do this:
> klabu_at_devzone> alter session set nls_date_format='dd-mon-yyyy hh24:mi:ss' ;
>
> Session altered.
>
>
> But NOT:
>
> klabu_at_devzone> alter session set sql_trace=true ;
> alter session set sql_trace=true
> *
> ERROR at line 1:
> ORA-01031: insufficient privileges
>
>
> Why ? It seems I can "alter session" but why "alter session set
> sql_trace=true" failed ?
> And How can I enable sql_trace ?
> Thx

Because you don't have the appropriate privilege just as the error message states.

You can learn more about this at http://tahiti.oracle.com

Look up SQL_TRACE.

-- 
Daniel Morgan
Puget Sound Oracle Users Group