Re: Dynamic SQL (DDL) - ORA-01031: insufficient privileges

From: Peter Laursen <ptl_at_edbgruppen.dk>
Date: 19 Jan 2000 08:15:50 GMT
Message-ID: <01bf6255$4eecb0a0$2c289a0a@apollo>

Henrik Bachmann <Henrik.Bachmann_at_bim-consulting.de> skrev i artiklen <38856537.81724403_at_news.topnet.de>...
> Hi there!
>
> Is anybody out there who can give me a hint?
>
> Consider the following procedure [Source: Oracle-Doc]:
>
> CREATE OR REPLACE PROCEDURE exec(STRING IN varchar2) AS

> The error "ORA-01031: insufficient privileges" occurs after calling
> the next statement (user with dba role):
> exec('create table acct(c1 integer)');
>
> After creating the table acct manually there is no error calling a
> statement like this:
>
> exec('drop table acct');
>

Henrik, I would say that the user needs create table priv granted directly, dba role is not enough. Roles are not active during procedure execution.

Peter Received on Wed Jan 19 2000 - 02:15:50 CST