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

Home -> Community -> Usenet -> c.d.o.server -> Re: execute DDL from an stored procecure, using native dynamic sql (ORA v8.1.6)

Re: execute DDL from an stored procecure, using native dynamic sql (ORA v8.1.6)

From: Jon <aaa_at_bbb.ccc>
Date: Wed, 21 May 2003 08:43:25 +0200
Message-ID: <baf75e$23m$1@unbe.sarenet.es>


thanks for both responses, they both may help me so I will go on doing some tests before. I have looked for help in the oracle manuals before posting this forum but I have found nothing and that, anyway sorry for the inconveninence you have been caused.

"Sybrand Bakker" <gooiditweg_at_nospam.demon.nl> escribió en el mensaje news:vvnkcvkho4vj5ntqrm193l9mh4pbjf78fl_at_4ax.com...
> On Tue, 20 May 2003 17:39:12 +0200, "Jon" <aaa_at_bbb.ccc> wrote:
>
> >
> >Hi,c onnected as a user with DBA role, I am trying to execute a procedure
> >with some
> >native dynamic sql statements embebed that tries to do some DDL
(...create
> >table), however,
> >when trying to run the stored procedure, and altough the user I am
connected
> >with has DBA role,
> >it returns the following error: ORA-01031: insufficient privileges. Do I
> >need any other
> >special privilege for running native dynamic sql and DDL instructions?
...
> >thanks
> >
>
>
> This question has been asked over and over and over again.
> Roles are being ignored during compilation of a stored procedures.
> You have privilege through a role, hence you don't have privilige in a
> stored procedure.
> You need (in order of preference)
> create procedure ... authid current_user
> (as this is 8i)
> or grant create table to the owner of the procedure directly (not
> preferred, as grants by SYS are not exported)
>
> PLEASE ALWAYS search google before posting a question of which you can
> assume it is a FAQ
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Wed May 21 2003 - 01:43:25 CDT

Original text of this message

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