Christian Gulich wrote:
> Thanks,
> in SQL+ your way works fine. I read the data from the table, construct a
> complete sql statement and execute it using "execute immediate". In this way
> it works fine.
> But if I do the same thing in a procedure (created and called by the same
> user who did it in the SQL+ interpreter) I get an error message, that I
> don't have the rights to do so.
> The error occurs in the line with "execute immediate".
> Are there some special rights to execute dynamic SQL from a procedure?
>
> Thanks
> Christian
>
>
privs acquired via a ROLE do NOT apply while excuting via PL/SQL engine.
The GRANTs issued to the ROLE must be explicitly GRANTED to the
procedure's owner.
Received on Sun Jun 13 2004 - 07:57:35 CDT
