Re: Creating Tables with Dynamic SQL

Grant the create table priviledge to the user explicitly.

grant create table to user_name

All the roles are disables during execution of the package.

Vijay Darekar

Phil Banham wrote:
>
> We have successfully used public package DBMS_SQL, running on Oracle
> V.7.3.3, to
> issue dynnamic SQL. This has worked for dropping & modifying tables, as
> well as
> accessing data. However when this pakage is used to create a table it
> gives the following
> error mesage:
>
> ERROR at line 1:
> ORA-01031: insufficient privileges
> ORA-06512: at "SYS.DBMS_SYS_SQL", line 239
> ORA-06512: at "SYS.DBMS_SQL", line 32
> ORA-06512: at "DMS.TEST", line 8
> ORA-06512: at line 1
>
> The user can create the same table directly from SQL*Plus, with no
> problems.
>
> Any advice would be appreciated.
>
> Regards,
>
> Phil Banham,
> UNIX/Oracle Administrator,
> European Space Agency,
> ESTEC,
> Netherlands.
Received on Fri Aug 22 1997 - 00:00:00 CDT