The problem is not in dbms_sql. You must grant create
table privilege to the user even if it heritages from
a role.
Regards.
- "Dmitriy M. Labutin" <Dmitriy_Labutin_at_ep.minsk.by>
wrote:
> 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_at_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_at_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).
Eng. Christian Trassens
Senior DBA
Systems Engineer
ctrassens_at_yahoo.com
ctrassens_at_hotmail.com
Phone : 541149816062
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christian Trassens
INET: ctrassens_at_yahoo.com
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_at_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).
Received on Fri Aug 31 2001 - 06:50:30 CDT