Re: Package question.

From: Normand Delisle <ndelisle_at_sympatico.ca>
Date: 1997/08/24
Message-ID: <01bcb0ba$587e2940$05f7acce_at_ysjqyhia>#1/1

Hi Stephen,

                 to show the content of a package, try describing it as you

would do with
a table. (i.e. SQL> desc PACKAGE_NAME).

        To grant the privileges, i think you have to create a public synonym for the
package, and grant execute privilege from public on the package.

               Good luck!!!
                     Frank Delisle.

Stephen <c6635500_at_comp.polyu.edu.hk> a écrit dans l'article <34010D17.2327_at_comp.polyu.edu.hk>...
> Hello all,
>
> I have a question about package.
> How to list the content of the package? When I type "select * from
> dba_object_size", it can show the package and its owner. But how can I
> know the content of the particular package?
>
> Moreover, is the package can be used by its owner? If so, how can grant
> the privilege to other users?
>
> Thanks,
> Stephen
>
Received on Sun Aug 24 1997 - 00:00:00 CEST