From Dmitriy_Labutin@ep.minsk.by Fri, 31 Aug 2001 05:10:57 -0700 From: "Dmitriy M. Labutin" Date: Fri, 31 Aug 2001 05:10:57 -0700 Subject: RE: Problem with DBMS_SQL Message-ID: MIME-Version: 1.0 Content-Type: text/plain Hi, Yes, that's right - thank you Cheers, Dimitri -----Original Message----- Sent: Friday, August 31, 2001 3:48 PM To: Multiple recipients of list ORACLE-L You have to directly grant privilege CREATE TABLE to this DL user Not via role Dynamic SQL counts only directly granted privileges Gints Plivna IT Sistēmas, Merķeļa 13, LV1050 Rīga http://www.itsystems.lv/gints/ "Dmitriy M. Labutin" To: Multiple recipients of list ORACLE-L Subject: Problem with DBMS_SQL Sent by: root@fatcity.com 2001.08.31 14:00 Please respond to ORACLE-L Dear All Every time when I try to create table with the DBMS_SQL I get error ----------- ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_SYS_SQL", line 782 ORA-06512: at "SYS.DBMS_SQL", line 32 ORA-06512: at "DL.SP_CR", line 6 ORA-06512: at line 2 ----------- The procedure code is trivial and I call it as begin sp_cr('CREATE TABLE XTTBL(a NUMBER)'); end; / CREATE OR REPLACE procedure SP_CR(pvi_str VARCHAR2) AS cid INTEGER; err_code INTEGER; begin cid := DBMS_SQL.OPEN_CURSOR; DBMS_SQL.PARSE(cid, pvi_str, DBMS_SQL.native); err_code:=DBMS_SQL.EXECUTE(cid); DBMS_SQL.CLOSE_CURSOR(cid); END; / What might be wrong here? Yes, I can try native SQL (I'm running 8i) but code has to be portable to the 8.05 Cheers, Dimitri -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dmitriy M. Labutin INET: Dmitriy_Labutin@ep.minsk.by Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: G.Plivna@itsystems.lv Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dmitriy M. Labutin INET: Dmitriy_Labutin@ep.minsk.by Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).