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

Adam Tadj <vahidt_at_dbsun.vitek.com> wrote in article <5bjlkh$cmv$1_at_newsin-1.starnet.net>...
> I am trying to to execte a DDL module using SQL_DMS.PARSE, but have'nt
> had any luck yet.
>

Do you get privilages via Oracle role (connect, resource)? DBMS_SQL check explicit privilages, grant CREATE VIEW explicitly.

> GRANT CREATE VIEW to OPS$A_USER;

and try again. Received on Thu Jan 16 1997 - 00:00:00 CST