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.