Hi Experts,
I have a mview "MYMVIEW" on SCHEMAA and I have granted "SELECT" on MYMVIEW to SCHEMAB.
On SCHEMAB I have created a synonym "MYVIEW" (with same name) for SCHEMAA.MYMVIEW
Now I want to refresh MYMVIEW from SCHEMAB using the synonym.
I checked on google, "GRANT ALTER ANY MATERIALIZED VIEW TO SCHEMAB" is required for this.
But I am not sure about the impact of ANY, as my SCHEMAA is having multiple mviews and I only wants to refresh some mviews from SCHEMAB.
I hope I am clear about my question.
Please help.
~Shalini