Site icon Database Tutorials

“ORA-01031: Insufficient Privileges” Error When Creating a Materialized View in a Different Schema

When a user tries to create a materialized view in a different schema, if the user of that schema does not have create table authority, the process of creating materialized view will result in an ORA-01031 error. In order to avoid this error, you must grant create table authorization to user/schema where materialized view is created.

In the following example, the “ahmet” user try to create a materialized view in the schema named “mehmet”.

When you grant CREATE TABLE privilege to “Mehmet” user, “Ahmet” user can successfully create materialized view in “Mehmet” schema.

 

Exit mobile version