Re: Error trying to activate session SQL tracing
From: Lun Wing San (Oracle) <"Lun>
Date: 1996/11/16
Message-ID: <328EC4BE.47A2_at_qrcsun.qrc.org>#1/1
Date: 1996/11/16
Message-ID: <328EC4BE.47A2_at_qrcsun.qrc.org>#1/1
Steve Rothkin wrote:
>
> In my Pro-C program, I have the statement:
> EXEC SQL ALTER SESSION SET SQL_TRACE = TRUE;
>
> At runtime this results in
> ORA-01031: insufficient privileges
>
> What do I need to do to allow this statement to succeed?
You can grant the ALTER SESSION system privilege to the user connected.
Related Topics: Packages, Roles
--- Name : Lun Wing San Title : Oracle Application Developer of Hong Kong Productivity Council Oracle Database Administrator and System Administrator of QRC Phone : (852)27885841Received on Sat Nov 16 1996 - 00:00:00 CET