Re: Error trying to activate session SQL tracing

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?
>
> --
> Steve Rothkin NYNEX Science and Technology
> email: srothkin_at_nynexst.com Room T5
> voice: (914) 644-5211 400 Westchester Avenue
> fax: (914) 644-2153 White Plains, NY 10604
 Grant the user account the Alter Session system privilege.

-- 
Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.