Materialized View Refresh [message #275911] |
Tue, 23 October 2007 06:02  |
blazingrock4u
Messages: 30 Registered: March 2006 Location: India
|
Member |

|
|
Hi,
I've got a materialized view MV1 in schema A1, which should be refreshed by B1. But the catch is I can't give ALTER ANY MATERIALIZED VIEW to B1 user to refresh A1.MV1
So, my question is, without having the ALTER ANY MATERIALIZED VIEW privilege, is there anyway one can refresh someone elses materialized view.
I';ve tried giving GRANT ALL ON A1.MV1 TO B1; and GRANT EXECUTE ON DBMS_SNAPSHOT TO B1;, but it didn't work. Everytime I try to
execute dbms_mview.refresh('A1.MV1','c'); I get: ORA-01031: insufficient privileges.
TIA.
|
|
|
|
|
|