Re: Privilege of dbms_sql?

You can create a view with dbms_sql only if you have the "create view" privilege directly not via a role.

--
Have a nice day
Michel

Ming Luo <ming_at_sol1.lrsm.upenn.edu> a écrit dans le message : 824k7f$663$1_at_netnews.upenn.edu...
> In SQL environment, I can excute the following line
>
> CREATE OR REPLACE VIEW viewName AS SELECT * FROM tableName <conditions>
>
> But, if I put the line in "dbms_sql.parse" and run the procedure, I get
>
> ORA-01031: insufficient privileges
> ORA-06512: at "SYS.DBMS_SYS_SQL", line 491
> ORA-06512: at "SYS.DBMS_SQL", line 32
> ORA-06512: at "OLDFAST.DEMO", line 50
> ORA-06512: at line 2
>
> Why? How to fix it?
>
> Thanks.
>
>
Received on Thu Dec 02 1999 - 02:51:34 CST