Name

Materialized Views

Synopsis

Provides privileges to perform operations on materialized views. Materialized views are preaggregated summaries used for business intelligence operations. Materialized views were new in Oracle8i. In Oracle8i, both materialized views and snapshots could have these privileges. For Oracle8 and previous versions, only snapshots could have these privileges.

Unique privileges

None.

Common privileges

DELETE, FLASHBACK, INSERT, SELECT, UPDATE. The DELETE, INSERT, and UPDATE privileges can be granted only on updatable materialized views.

Get Oracle in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.