My Oracle Support Banner

Materialized View Privileges Needed for Local & Remote Databases to Prevent ORA-1031 & ORA-942 (Doc ID 1231613.1)

Last updated on NOVEMBER 07, 2023

Applies to:

Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.

Purpose

This Document has been created to provide the correct minimum privileges required to build a local or remote Materialized View ( MVIEW ) in the same or different schema.

Scope

Any one requiring any of the GRANT options to build an MVIEW and/or MVIEW Log (Materialized View and/or Materialized view log).

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Purpose
Scope
Details
 NB.    Creating Materialized views with User privileges granted via a ROLE
 Test 1 - Creates a basic mview under the owner of the master table.
  Test 2 - Creates a basic mview under the owner of the master table where the master table requires a materialized view log. 
 Test 3 - Creates a basic mview under a different owner to its master table where the master table requires a materialized view log.
 Test 4 - creates a simple mview based on a table in a remote database that has a different master table owner to the mview and an mview log.
 Documented Privileges for Mviews
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.