Refreshing materialized view

I have a materialized view, and I need refresh it on demand with a different user than the one who created it. Which privileges does this user need to refresh the materialized view?

    Requires Free Membership to View

If the user refreshing the Materialized View (MV) does not own the MV, then you can grant ALTER ANY MATERIALIZED VIEW to that user. This user will be able to alter any MATERIALIZED VIEW in the system. Check out this Oracle doc for more information:

This was first published in October 2003

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.