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: want to see code of stored procedure but without permission to execute it

Re: want to see code of stored procedure but without permission to execute it

From: Benny <benny.derous_at_gmail.com>
Date: Fri, 28 Sep 2007 12:58:00 -0000
Message-ID: <1190984280.790745.293880@d55g2000hsg.googlegroups.com> 





Found something : in Oracle9i you still need an execute grant (debug
is not enough) but in 10g a debug grant is enough (you see the code in
all_source)


So it depends on the Oracle version.


Thanx guys,


Benny.
Received on Fri Sep 28 2007 - 07:58:00 CDT












Original text of this message













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