Re: ORA-01031 in execution of procedure with DBMS_UTILITY.EXEC_DDL_STATEMENT

On Mon, 14 Jan 2002 18:13:03 +0100, "fly13" <bll_at_netsecuresoftware.com> wrote:

>Hi,
>
>I would like to know why i have the error ORA-01031 when i execute the
>procedure.
>
>createquery='create table xxxx as (select * from yyyy where a=b)'
>DBMS_OUTPUT.PUT_LINE(createquery)
>DBMS_UTILITY.EXEC_DDL_STATEMENT(createquery)
>
>SQL>set serveroutput on
>SQL>exex proc1
>create table xxxx as (select * from yyyy where a=b)
>
>ORA-01031 : insuficients privileges
>
>but, when i execute this command (create table xxxx), there is no problem.
>Is it a privilege on the package? No! i grant execute on this package to my
>user.
>
>Can anybody could explain me what i have done wrong???
>
>Cheers.
>

Roles (as usual). You'll find out which privilege you have through a role.

Regards

>Fly
>
>
>

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Jan 14 2002 - 12:37:24 CST