Hi Govindan Good thought!!, I was going to suggest the same idea, just to go and get the description of the package / procedure / function from the dictionary and then grant access to the dictionary views needed.
One slight flaw with your code though, you have selected from user_% views but the OP wanted to be able to let another user describe *his* procedures and packages, you would need to use dba_% views as if the "other" person had not been granted access to the OP's procedures then they wouldn't be in ALL_% for him or in user_% views. kind regards Pete In article <[EMAIL PROTECTED]>, Govindan K <[EMAIL PROTECTED]> writes >This was the closest i could get. > >set pagesize 60; >set linesize 180; >column position noprint; >column sequence noprint; >break on object_type skip 1; >break on package_name skip 1; >break on object_name skip 1; >column object_type format A15 wrap; >column package_name format A30 wrap; >column object_name format A30 wrap; >column argument_name format A30 wrap; >column in_out format A10 wrap; >column data_type format A15 wrap; >column default_value format A10 wrap; >column type_name format A10 wrap; >column type_subname format A10 wrap; >select > b.object_type > ,a.package_name > ,a.object_name > ,a.argument_name > ,a.position > ,a.sequence > ,a.in_out > ,a.data_type > ,a.default_value > ,a.type_name > ,a.type_subname > from user_arguments a > ,user_objects b > where a.position > 0 > and b.object_id = a.object_id > order by > b.object_type > ,a.package_name > ,a.object_name > , a.position >/ > >Create a procedure which will dbms_output this and grant execute >priviliges on it. > ><-----Original Message-----> > > From: Gary Jackson >Sent: 9/30/2003 9:31:29 AM >To: [EMAIL PROTECTED] > >(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! > >_________________________________________________________________ > >Author: Gary Jackson >INET: [EMAIL PROTECTED] > >. > > >_______________________________________________________________ >Get Your 10MB account for FREE at http://mail.arabia.com ! >Access MILLIONS of JOBS NOW! ><http://ads.arabia.com/?SHT=text_email_english> -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan 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).
