runesl_at_my-dejanews.com wrote in article
<6li86u$v08$1_at_nnrp1.dejanews.com>...
> Hi!
>
> I have two schemas adb and cdb on the same Oracle 7.3 server. In the adb
> schema I have created a package with a procedure which tries to access
data
> from a table in the dfo schema. When I try to create the package, I'll
get
> the errors shown below.
>
> Anybody know how to refer to a table in another schema? The insert
statement
> works fine alone in SQL+, logged in as the same user who tries to create
the
> package below.
>
You must grant the select privilege to the dfo table expicitly to the adb
schema (not through a role).
Login to the dfo schema and type:
grant select on cable to adb;
Received on Wed Jun 10 1998 - 21:35:55 CDT
