Re: enable SQL trace with trigger?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 11 Jul 1999 10:32:47 +0100
Message-ID: <931686092.23191.1.nnrp-08.9e984b29@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 - 04:32:47 CDT