| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: DDL in Dynamic PL/SQL
<HTML>
You need explicit CREATE TABLE permission. Role based permissions don't
work.
<P>Dick Willis wrote:
<BLOCKQUOTE TYPE=CITE>Trying to create a table that I don't know the name
of a priori. I am
<BR>therefore using Dynamic PL/SQL in my procedure to perform the CREATE
TABLE
<BR>function.
<P>Procedure compiles fine ...
<P>Pseudo code is:
<P> Get table name
<BR> Build SQL string
<BR> Open cursor with DBMS_SQL.OPEN_CURSOR
<BR> Parse SQL statement for cursor DBMS_SQL.PARSE
<BR> Execute on cursor DBMS_SQL.EXECUTE
<P>Problem is that when procedure is called, it fails at the .PARSE step
with
<BR>an 'insufficient privilege' error.
<P>Any clues? Am creating the function in an account with the DBA
role
<BR>assigned. Also calling it from the same account, so I thought
I had the
<BR>privileges nailed. Same code with UPDATE, SELECT, etc. works
OK. Seems to
<BR>be solely due to DDL SQL call.
<P>--
<BR>Dick Willis, Senior Engineer
<BR>Synchrony Industrial Controls, Inc.
<BR>rmw_at_synchrony.com
<BR>http://www.synchrony.com</BLOCKQUOTE>
</HTML>
Received on Thu Oct 23 1997 - 00:00:00 CDT
 |
 |