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

From: Jerome Vitalis <vitalis..._at_gmail.com>
Date: 25 Sep 2007 11:57:53 GMT
Message-ID: <46f8f7c1$0$26093$426a34cc@news.free.fr>

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.

---

échangez opinions et commentaires dans les forums de discussion. http://www.usenetgratuit.com/ Received on Tue Sep 25 2007 - 06:57:53 CDT