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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

MVIEW refresh using synonym at another schema

3154057Dec 13 2016 — edited Dec 13 2016

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 10 2017

Added on Dec 13 2016

5 comments

757 views