Yes, that's correct.
Since the only privilege available on a code object is "execute", it
doesn't make much sense to allow a user to DESCRIBE the call interface
if the user cannot run it.
- Gary Jackson <fred_fred_1_at_hotmail.com> wrote:
> (Reposting from yesterday morning since I had no takers! :)
>
> Hello,
> I wanted to give another user access to view my procedures & packages
> (just
> DESC capability), but it seems that the only way for him to be able
> to DESC
> them is for me to grant execute. Is this correct?? (I guess I have
> never
> had this situation before, it just seems surprising if there is no
> way to
> grant a read-only privilege).
>
> Thanks!
>
> _________________________________________________________________
> Get MSN 8 Dial-up Internet Service FREE for one month. Limited time
> offer--
> sign up now! http://join.msn.com/?page=dept/dialup
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Gary Jackson
> INET: fred_fred_1_at_hotmail.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Paul Baumgartel
INET: treegarden_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Sep 30 2003 - 15:04:28 CDT
