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

Many session parameters can be changed without 'alter session' privilege; all you need is 'create session'. NLS_DATE_FORMAT is one of such parameters. SQL_TRACE is different; you do need 'alter session' to change it. Take a look at ALTER SESSION description in SQL Reference.

Regards,
Igor Received on Mon Oct 02 2006 - 19:37:19 CDT