Re: Using EXCUTE IMMEDIATE in PL/SQL

Hi,

You have the "create table" from a role, you have to grant it directly to the user. privileges granted through a role don't work within PL/SQL.

Bye
  Jos

Alexandros Kotsiras, NYC <alexandros_k_at_prodigy.net> schreef in berichtnieuws 394D6F73.C4005C54_at_prodigy.net...
> CREATE OR REPLACE PROCEDURE TEST_PROC AS
> begin
> execute immediate 'create table TEST_1 as select * from TEST ' ;
> end;
>
> I receive :
> ORA-01031 Insufficient privileges
>
> Why that ? ?
> I do not have problems with procedures that do not have "execute
> immediate" inside.
> I am the owner of the procedure and the TEST table.
> If i execute the create table statement directly from SQL*Plus it works
> fine ....
>
> The description of the error message in the documentation doesn't really
> help.
>
Received on Mon Jun 19 2000 - 00:00:00 CDT