Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 'insufficient privileges' from DBMS_SQL.PARSE call
Hi unknown :-),
hlh_nospam_at_excite.com schrieb in Nachricht
<7f2nst$na8$1_at_nnrp1.dejanews.com>...
>
>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 "CENTRA3.BENG0008", line 14
>ORA-06512: at line 1
>
>Is this an Oracle configuration problem? How do I get over it?
>
before submitting DDL with dbms_sql, explicitly grant the privilege to the user where the dbms_sql should run. in this case, as system 'grant create view to [username]'.
regards,
--Marcus
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Apr 14 1999 - 19:46:57 CDT