ORA-01031: insufficient privileges raised during materialized view creation on another schema
Scenario: ORA-01031: insufficient privileges raised during the creation of materialized view (MVIEW) on another schema by the SYSTEM user. CREATE MATERIALIZED VIEW kaysar.mview_test BUILD IMMEDIATE AS (SELECT * from kaysar.test); [Error] Execution (4: 26): ORA-01031: insufficient privileges Investigation: The SYSTEM already has the privilege of CREATE_MATERIALIZED_VIEW to create the MVIEW on another schema but failed…