Re: Accessing tables from another Schema

From: <dnotari_at_yahoo.com>
Date: Thu, 06 May 1999 18:14:41 GMT
Message-ID: <3731dbb2.4536803@newshost.us.oracle.com>

Jens,
note that procedures and functions (within package or not) are executed with the privileges and within the schema of the owner(!) of the function, not the executor.

Make sure that the owner of the table has access to the table. Otherwise it should work fine.

Regards
Dante
On Thu, 06 May 1999 16:44:28 +0200, 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
Received on Thu May 06 1999 - 13:14:41 CDT