Skip to Main Content

Oracle Database Discussions

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!

Missing grants for running Materialized view

YoavMar 18 2010 — edited Mar 18 2010
Hi,
Version 10204.

I have a materialized view named ABC owned by user TEST.
I am tring to refresh to materialized view by another user (TEST2)
I am getting ORA-01031: insufficient privileges.
GRANT SELECT,REFERENCES ON TEST.ABC TO TEST2 WITH GRANT OPTION;
GRANT EXECUTE ON TEST.ABC TO TEST2;
BEGIN
  DBMS_SNAPSHOT.REFRESH(
    LIST                 => 'TEST.ABC'
   ,METHOD               => 'F'
   ,PUSH_DEFERRED_RPC    => TRUE
   ,REFRESH_AFTER_ERRORS => FALSE
   ,PURGE_OPTION         => 1
   ,PARALLELISM          => 0
   ,ATOMIC_REFRESH       => TRUE
   ,NESTED               => FALSE);
END;
/
ERROR at line 1:
ORA-01031: insufficient privileges
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
Which grants are missing ?

Thanks                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 15 2010
Added on Mar 18 2010
12 comments
35,576 views