Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie: Select in PL/SQL
See GRANT statement syntax to give grants for database objects.
e.g. you can:
grant ALL on <Some table> to <Some user or role> [WITH GRANT OPTION];
"GREGORY KNESER" <gregoryk_at_futures.wharton.upenn.edu> a écrit dans le
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 - 08:59:38 CST