Re: CREATE TABLE using DBMS_SQL

Bradley,

I suspect the problem is that the compiling ID has the create table privilege granted through a role. Privileges granted through a role do not work when invoked from a stored procedure.

I just ran into a similar error using dbms_sql and got around it by making sure that the necessary privilege was granted explicitly to the compiling ID.

Bradley Safer <bradley.safer_at_hbo.com> wrote in article <34E1E14B.F49E6642_at_hbo.com>...
> From page 10-2 of the Oracle7 Server Application Developer's Guide:
> "Additionally, you can parse any data manipulation language (DML) or
> data definition language (DDL) statement using the DBMS_SQL package."
>
> When I make calls to the following procedure I get: "ORA-01031
> Insufficient Privileges" however, when issuing the DDL contained in
> "createString" at the SQL*Plus command line under the same id it works
> fine:
Received on Wed Feb 11 1998 - 00:00:00 CST