Re: Describe privilege on procedures & packages

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" <ORACLE-L_at_fatcity.com> 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 <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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

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