Ask the Expert

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: