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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).