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