Re: enable SQL trace with trigger?

From: Royce Lithgo <roycel_at_bml.com.au>
Date: Mon, 12 Jul 1999 08:39:32 +1000
Message-ID: <G29i3.2346$1u.22896@ozemail.com.au>

Hi,

as I said in my original post, if I execute the statement directly (ie in SQL*Plus) it works. Execute permission has already been granted. Any other ideas?

Royce.

Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote in message news:931686092.23191.1.nnrp-08.9e984b29_at_news.demon.co.uk...
> Try granting ALTER SESSION directly to the id owning
> the table. It may be the usual problem of roles not being
> enabled You migh also try granting EXECUTE on DBMS_SESSION
> directly to the ID as well.
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
> Royce Lithgo wrote in message ...
> >Hi,
> >
> >is it possible to enable SQL trace within a trigger? I'm trying to do it
> >and I keep getting 'ORA-01031: insufficient privileges'
> >Here is the trigger:
> >
> >create trigger mb_prcs_req_aft_ins_row
>
>
>
Received on Sun Jul 11 1999 - 17:39:32 CDT