Re: Newbie: Select in PL/SQL

grant select etc to each table from the user that owns them

then you can create private or public synonyms to access them

S

"GREGORY KNESER" <gregoryk_at_futures.wharton.upenn.edu> wrote in message news:9rg9hg$7pl$2_at_netnews.upenn.edu...
> Hello,
>
> We're having problems with selects in our pl/sql statements. We can do
> selects just fine except for the situations where the table we want to
> select from is outside of the schema that the stored procecdure is
> located in. What can we do to give the stored procedures the ability to
> see tables outside of their own schema? All users have been granted the
> DBA role.
>
> Thanks,
> Greg
Received on Sun Oct 28 2001 - 13:16:06 CST