Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: want to see code of stored procedure but without permission to execute it
Benny wrote:
> 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.
BTW what do you mean exactly by "see the code"? By means of the standard dictionary views and tools such as SQL Developer? Otherwise you can still create a materialized view on FLX0's user_source and grant select on it to FLX0_RO.
![]() |
![]() |