Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> "alter session set sql_trace" Privilege

"alter session set sql_trace" Privilege

From: klabu <klabu76_at_gmail_dot_com>
Date: Mon, 2 Oct 2006 11:22:38 -0400
Message-ID: <12i2blvn1l7rg8a@corp.supernews.com>


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 Received on Mon Oct 02 2006 - 10:22:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US