Oracle-L: Re: Describe privilege on procedures & packages

From: Govindan K <gkatteri_at_omanmail.com>
Date: Tue, 30 Sep 2003 17:39:27 -0800
Message-ID: <F001.005D18B9.20030930173927@fatcity.com>

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>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Govindan K
  INET: gkatteri_at_omanmail.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 - 20:39:27 CDT