Re: tracing an sql session?

From: gazzag <gareth_at_jamms.org>
Date: 16 Jan 2007 08:12:23 -0800
Message-ID: <1168963942.140249.4280@51g2000cwl.googlegroups.com>

DA Morgan wrote:
> conn / as sysdba
>
> grant ALTER SESSION to <schema>;
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org

Doh. In addition to my earlier post:

To "alter session set events..." you need to log into the database with

an account that has DBA privileges.... and *then* grant the ALTER SESSION privilege to the user in question :-)

Sorry... long day.

-g Received on Tue Jan 16 2007 - 10:12:23 CST