Re: Describe privilege on procedures & packages

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 <F001.005D18B9.20030930173927_at_fatcity.com>, Govindan K <gkatteri_at_omanmail.com> 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: ORACLE-L_at_fatcity.com
>
>(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: fred_fred_1_at_hotmail.com
>
>.
>
>
>_______________________________________________________________
>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:pete_at_petefinnigan.com
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: oracle_list_at_peterfinnigan.demon.co.uk

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).