Re: PL/SQL: DBMS_SQL Package...

In article <351084C6.36AF_at_connico.net>,   mrosadino_at_connico.net wrote:
>
> Hi:
> I have a question regarding the DBMS_SQL package provided through the
> Oracle 7 server; we have Oracle 7.3 currently installed on an HP-UX 3000
> server and we've been experimenting with stored procedures which make
> use of the DBMS_SQL package [which we call from an Oracle 4.5 Forms
> app]. In our code, we are passing SQL DDL statements into the stored
> procedure for execution & commit. It appears that the only way we can
> successfully execute these procedures is if the stored procedure is
> stored under the SYS owner. Does anyone know of a way to store the
> procedure under a userspace while designing/debugging so that the code
> could be executed successfully from the userspace without having to port
> it to the SYS owner?
> --
> Michael Rosadino
> E-mail(W): mrosadino_at_ggtinc.com
> Work: (860)871-8082, x3484
>

You have to make grants for each ddL command you want to execute with DBMS_SQL. If you want to execute "CREATE TABLE.." with DBMS_SQL your previous job is to grant "create table" to the user of dbms_sql. This is because the privileges you get by roles have no implications on DBMS_SQL.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Mar 19 1998 - 00:00:00 CET