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: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 05 Mar 2004 23:00:54 +0100
Message-ID: <lamh40157isdu2uk0g645ov89qoeksh1bf@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
Received on Fri Mar 05 2004 - 16:00:54 CST

Original text of this message

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