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

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Mon, 14 Jan 2002 18:12:37 GMT
Message-ID: <3c431f4f.556961672@news.alt.net>

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.
>
>Fly

SQL>host oerr ora 1031
01031, 00000, "insufficient privileges"
// *Cause: An attempt was made to change the current username or password
// without the appropriate privilege. This error also occurs if
// attempting to install a database without the necessary operating

//         system privileges.
//         When Trusted Oracle is configure in DBMS MAC, this error
may occur
//         if the user was granted the necessary privilege at a higher
label
//         than the current login.

// *Action: Ask the database administrator to perform the operation or grant

//          the required privileges.
//          For Trusted Oracle users getting this error although
granted the
//          the appropriate privilege at a higher label, ask the
database
//          administrator to regrant the privilege at the appropriate

label.

HTH,
Brian Received on Mon Jan 14 2002 - 12:12:37 CST