Re: Accessing tables from another Schema

From: <shelbyko_at_my-dejanews.com>
Date: Thu, 06 May 1999 16:34:24 GMT
Message-ID: <7gsgah$53v$1@nnrp1.deja.com>

You have to expicitly grant access to the table, to the schema owning the package. Access granted through a role won't be enough.

Shelby
In article <3731AACC.20F37C9F_at_ratundtat.com>, Jens Mayer <jmayer_at_ratundtat.com> wrote:
> Hi folks !
>
> I want to access a table from within a package which was created in
> another schema. This doesn't work, even if I use the schema prefixing
> the table name. If I create the package in the same schema as the table,
> it works fine. Are there any package-specific restrictions in accessing
> objects of another schema ?
>
> Jens
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu May 06 1999 - 11:34:24 CDT