Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: alter session set sql_trace inside a procedure

Re: alter session set sql_trace inside a procedure

From: FC <flavio_at_tin.it>
Date: Fri, 05 Mar 2004 23:17:34 GMT
Message-ID: <iU72c.4000$z23.159047@news3.tin.it>

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:lamh40157isdu2uk0g645ov89qoeksh1bf_at_4ax.com...
> On Fri, 05 Mar 2004 19:26:30 GMT, "VC" <boston103_at_hotmail.com> wrote:
>
> >You have to grant the alter session privilege directly, granting via a
role
> >is not sufficient:
> >
> >grant alter session to <user>
> >
> >... or use AUTHID CURRENT_USER which is not advisable.
> >
> >
> >VC
> >
> >>
>
> Could you explain? *Direct* grants are a maintenance nightmare, as
> they are granted by SYS and not exported.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

I agree, still I don't understand why it doesn't work via role...

I thought it could be some sort of bug connected with the "special" resource role, but even creating a new role and assigning the privilege to it doesn't solve the problem.

Bye,
Flavio Received on Fri Mar 05 2004 - 17:17:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US