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: z1hou1 <z1hou1_at_gmail.com>
Date: Thu, 27 Sep 2007 02:12:25 -0000
Message-ID: <1190859145.870041.15110@g4g2000hsf.googlegroups.com> 





I was wondering whether owner FLX0 should simply
GRANT SELECT on <proceudure> TO FLX0_R0



and to be safe do a


REVOKE EXECUTE grant from the stored procedure.



I am thinking that in this case the procedure will be readable,
meaning you can do a SELECT TEXT from ALL_SOURCES WHERE NAME=<> and
OWNER='FLX0' ORDER BY line.



Regards,


z1hou1
Received on Wed Sep 26 2007 - 21:12:25 CDT












Original text of this message













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