Re: SQL_DMS.PARSE:Problem with Some DDL's (create view ....)

Adam Tadj wrote:
>
> I am trying to to execte a DDL module using SQL_DMS.PARSE, but have'nt
> had any luck yet. My intention is to use it for the creating views
> dynamically. There error says "insufficient privileges", but we tried
> it from the DBA account and got the same result. Here is the PL/SQL:
 

> I would like to mention I can create an index on a table or run a
> SELECT or UPDATE commands with this built in procedure without any
> problem. This only occurs when creating a view or a table and that
> when it is executed from a procedure. If I ran the code interactively
> (declare .begin ....) it works fine.

All priviledges on base table must be directly grant to the user who wants to
create the view on it, but not through a role.

-- 
Hui, Kwok Miu (Xu, Guo Miao)         E-Mail: huikomix_at_dt.com.hk
Assistant MIS Manager                Tel   : (00852)2589 3369
Cho Yang (Hong Kong) Co., Ltd.       Fax   : (00852)2559 3049