Re: Q: 'insufficient privileges' from DBMS_SQL.PARSE call

hlh_nospam wrote on 14-Apr-99 19:48:00:
>I would like to create a view at runtime. I can easily do this from
>the SQL*Plus command line, e.g.,

[...]

>Procedure created.

SQL>> execute beng0008;
>CREATE VIEW sec_psf_effective_view AS SELECT * FROM sec_psf WHERE
>psf_part <> psf_assy begin beng0008; end;

>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?

You most likely have the 'create view' system privilege granted through a role. This does not work within PL/SQL! You need to get the privilegue granted directly to the user.

Hope that helps,
Lothar

--

Lothar Armbrüster       | lothar.armbruester_at_rheingau.netsurf.de
Schulstr. 12            | lothar.armbruester_at_t-online.de
D-65375 Oestrich-Winkel |