![materialize select materialize select](https://materializecss.com/images/sample-1.jpg)
To create a refresh-on-commit materialized view ( ON COMMIT REFRESH clause), in addition to the preceding privileges, you must have the ON COMMIT REFRESH object privilege on any master tables that you do not own or you must have the ON COMMIT REFRESH system privilege. The owner must also have access to any master tables of the materialized view that the schema owner does not own (for example, if the master tables are on a remote database) and to any materialized view logs defined on those master tables, either through a SELECT object privilege on each of the tables or through the SELECT ANY TABLE system privilege. The owner of the materialized view must have the CREATE TABLE system privilege. You must have the CREATE ANY MATERIALIZED VIEW system privilege.
![materialize select materialize select](https://i.stack.imgur.com/x8jTU.jpg)
To create a materialized view in another user's schema: You must also have access to any master tables of the materialized view that you do not own, either through a SELECT object privilege on each of the tables or through the SELECT ANY TABLE system privilege. You must have been granted the CREATE MATERIALIZED VIEW system privilege and either the CREATE TABLE or CREATE ANY TABLE system privilege. To create a materialized view in your own schema: The privileges required to create a materialized view should be granted directly rather than through a role.
![materialize select materialize select](https://i.ytimg.com/vi/DemT1iWDnHk/maxresdefault.jpg)
Oracle Data Warehousing Guide for information on the types of materialized views used to support data warehousing