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

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

From: Benny <benny.derous_at_gmail.com>
Date: Tue, 25 Sep 2007 05:38:03 -0000
Message-ID: <1190698683.044487.212350@57g2000hsv.googlegroups.com> 





Hi people,


is it possible in Oracle9i/10g to grant a user permission to see the
code of someone else's procedure but without the permission to execute
this procedure ?


And I do not want to give this user the system privilege 'select any
dictionary' because then he can see everything in the entire database.



example : I want Oracle user "FLX0_RO" able to see the code of a
procedure from owner "FLX0". But FLX0_RO may not be able to execute
the procedure.



Is this possible with standard Oracle grants ?



Thanx.


Benny.
Received on Tue Sep 25 2007 - 00:38:03 CDT












Original text of this message













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