Re: DBMS_SQL 8.0.5 Bug?

Dan,

Has your package owner user got 'create any table' privilege directly? I use a packaged DBMS_SQL procedure to build synonyms and I needed to give the package owner the 'create any package' privilege directly - not through a role.

Incidentally, AFAIK you don't need to EXECUTE a DDL statement in DBMS_SQL. The PARSE operation executes DDL statements directly. This is probably why you're seeing the error in the PARSE operation.

Another thing I found out is that the DBMS_SQL package is no longer 'safe', so it can't be used in any functions you want to put inside SQL syntax.

HTH, David.

DanHW wrote:

> I have a package that uses DBMS_SQL.SQL to create a table. Works fine on 8.0.4,
> but in 8.0.5 it gives me 'insufficent priv'. I can run the script from SQL*Plus
> with no problems, so it has something to do with with the fact it is a package.
> Some other observations:
> 1. The table is to be owned by the user [same schema]
> 2. SYS nor SYSTEM can run it either.
> 3. CREATE table and CREATE index are affected, SELECTs , UPDATEs, INSERTS are
> fine
> 4. Error occurs on the DBMS_SQL.PARSE call, not the DBMS_SQL.EXECUTE call
> 5. Have rebuilt the DBMS_SQL and DBMS_SYS_SQL packages (repeatedly, actually)
> 6. Granted roles explictly to the user to no avail.
>
> This is a new installation...did something go wrong on the install? or is there
> a bug in 8.0.5?
> (8.0.4 on NT, 8.0.5 on Alpha)
>
> Thanks for any suggestions...
>
> Dan Hekimian-Williams
Received on Tue Jun 08 1999 - 04:11:51 CEST