Re: Describe privilege on procedures & packages

[Govindan K]

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.ty! pe_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] Subject: Re: Describe privilege on procedures & packages  (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!