Re: package visibility

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 15 Dec 2000 00:10:30 +0100
Message-ID: <91drl5$3tj81$3@ID-62141.news.dfncis.de>

You'll also need to create private or public synonyms.

Create [public] synonym <package name> for <owner>.<package name> If you don't do that you have prefix the package call with the owner. That should work already after your grant.

Hth,

Sybrand Bakker, Oracle DBA

<shdu_at_my-deja.com> wrote in message news:91bit4$j8k$1_at_nnrp1.deja.com...
> How do I make a package available to other accounts. The packages I
> wrote works only in my account. When I run our application server, which
> connects to the database under a different account, the packages are not
> visible. I ran the command "grant all on package_name to public" for all
> my packages but it still did not help.
>
> Thanks.
>
> SF
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Thu Dec 14 2000 - 17:10:30 CST