Re: Newbie: Select in PL/SQL

By default roles are disabled in plsql code - unless you are using the 8i feature - invoker rights method.

See here for details -

http://govt.oracle.com/~tkyte/Misc/RolesAndProcedures.html

HTH,.
Ora600

GREGORY KNESER wrote:

> 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 Nov 25 2001 - 17:15:49 CST