want to see code of stored procedure but without permission to execute it
- From: Benny <benny.derous@xxxxxxxxx>
- Date: Tue, 25 Sep 2007 05:38:03 -0000
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.
.
- Follow-Ups:
- Re: want to see code of stored procedure but without permission to execute it
- From: Chris ( Val )
- Re: want to see code of stored procedure but without permission to execute it
- From: Jerome Vitalis
- Re: want to see code of stored procedure but without permission to execute it
- From: Jerome Vitalis
- Re: want to see code of stored procedure but without permission to execute it
- Prev by Date: Re: Interesting blog post
- Next by Date: Re: want to see code of stored procedure but without permission to execute it
- Previous by thread: new statspack install seems to hang
- Next by thread: Re: want to see code of stored procedure but without permission to execute it
- Index(es):
Relevant Pages
|
