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

From: Chris ( Val ) <chrisval_at_gmail.com>
Date: Tue, 25 Sep 2007 06:39:37 -0700
Message-ID: <1190727577.990402.84310@57g2000hsv.googlegroups.com>

On Sep 25, 3:38 pm, Benny <benny.der..._at_gmail.com> wrote:
> 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 ?

Check out the USER_SOURCE table.

Perhaps you could create a view based upon this table, and grant appropriate permission on that view?

Cheers,
Chris Received on Tue Sep 25 2007 - 08:39:37 CDT