Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

insufficient privileges during dbms_mview.refresh

715292Jan 28 2010 — edited Jan 28 2010
Hi All,

Getting the below error while trying to refresh the materialized view.
Error starting at line 1 in command:
BEGIN
dbms_mview.REFRESH ('MAT_V', 'COMPLETE');
END;
Error report:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 350
ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 432
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2251
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2457
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2426
ORA-06512: at line 2
01031. 00000 -  "insufficient privileges"
I have given below rights to the user.
GRANT SELECT ANY DICTIONARY  TO vd_user;
GRANT ALTER ANY MATERIALIZED VIEW TO vd_user;
GRANT CREATE ANY MATERIALIZED VIEW TO vd_user;
Thanks,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 25 2010
Added on Jan 28 2010
4 comments
13,403 views