Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: table type

Re: table type

From: anacedent <anacedent_at_hotmail.com>
Date: Sun, 13 Jun 2004 05:57:35 -0700
Message-ID: <1bYyc.67464$tI2.56273@fed1read07>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US