Re: Weird thing (access not granted to a table from a procedure)

Antoine wrote:

> Hi,
>
> I have just created a procedure in a package with the system right.
>
> From the system account, i can run sql commands like select * from
> username.tablename.
>
> But, the procedure body is not compiled 'cause it pretends
> username.tablename should be declared first (and when i copy and paste the
> select statement, it runs perfectly, on the same account).
>
> Thx in advance
>
> Antoine

It appears that the access to the table is granted through a role. For compiled code such as packages and procedures the grant must be directly to the schema that owns the code.

Daniel Morgan Received on Mon Jun 24 2002 - 10:32:16 CDT