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