Hi! But if this procedure runs in definer rights under schema where the objects exist, then it should be possible?
Tanel. ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, October 01, 2003 1:59 PM > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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).