Re: Packages, stored procs and grants...

Hi Kevin,

On Tue, 11 Aug 1998 14:36:36 -0700, Kevin Skaalrud <kevin_skaalrud_at_neptune.serca.com> wrote:

>I have created a package that has two
>functions, and some initalization code.
>
>User x created the package and package body.
>
>User x granted execute to user y.
>User x created a synonym to userx.package &

This will only work if user x creates a public synonym for his package, i.e.: Connect to user x and then: CREATE PUBLIC SYNOYNM package_name FOR package_name

If you do not want to use public synonyms, it is necessary that either:

• User y creates a private synonym pointing to user x's package, i.e: Connect to user y and then: CREATE SYNONYM package_name FOR x.package_name

or

• User x has the 'create any synonym' privilege and creates a synonym private to user y pointing to user x's package, i.e.: Connect to user x and then: CREATE SYNONYM y.package_name FOR x.package_name

>granted execute to user y.
>
>Everything seemed to go ok. However, user y gets a
>invalid column name when he performs:
>
>select synonym.funct from dual;
> *
>
>Are there some grants that I am missing?

BTW, if you wish to use packaged functions in a SQL statement, you must take care of a correct PRAGMA RESTRICT_REFERENCES declaration.

HTH,
Peter

--
Peter Schneider
peter.schneider_at_okay.net Received on Tue Aug 11 1998 - 17:15:42 CDT