OraFAQ Forum: Replication » create materialized view + insufficient privileges

Home » Server Options » Replication » create materialized view + insufficient privileges (Oracle 8.1.7.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

create materialized view + insufficient privileges [message #300236]

Thu, 14 February 2008 12:03

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

CREATE MATERIALIZED VIEW Matview1
NOLOGGING
NOCACHE
NOPARALLEL
REFRESH COMPLETE ON DEMAND
START WITH sysdate
NEXT sysdate + 1
WITH ROWID
ENABLE QUERY REWRITE AS
select Query;

if i run select query it works fine .. also the user has create materialized view and query rewrite privs .. not sure why i am getting insufficient privileges error still ..

Can you tell me what is missing here ..

Report message to a moderator