The admin user and the owner of the database have all privileges
on materialized views by default. For all other users, the following
table lists the privileges that are required for the tasks that are
associated with materialized views.
Table 1. Materialized
view privileges
| Task |
Privilege |
| Create an SPM view |
Assign the Create Materialized View administration privilege. |
| Alter an SPM view |
Assign the Alter object privilege for a specific view or the
View object class. |
| Drop an SPM view |
Assign the Drop object privilege for a specific view or the
View object class. |
| Select from an SPM view |
Assign the Select object privilege for a specific view or the
View object class. |
| Alter views on a table |
Assign the Insert object privilege for a specific view or the
Table object class. |
| List on SPM views |
Assign the List object privilege for a specific view or the
View object class. |