ORA-01031: Insufficient Privileges When Create a Mview in Different Schema
(Doc ID 749112.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 126.96.36.199 [Release 10.2 to 12.2]
Information in this document applies to any platform.
Creating materialized view in other schema reports error ORA-01031.
User has CREATE ANY TABLE,CREATE ANY VIEW,CREATE ANY MATERIALIZED VIEW
conn /as sysdba
create user test identified by test;
grant SELECT ANY TABLE,CREATE ANY MATERIALIZED VIEW,CREATE ANY TABLE,CREATE SESSION to test;
create user user1 identified by user1;
grant resource,create session to user1;
grant unlimited tablespace to test;
create table t (a number);
alter table t add primary key (a);
SQL> create materialized view user1.t_mv as select * from user1.t;
create materialized view user1.t_mv as select * from user1.t
ERROR at line 1:
ORA-01031: insufficient privileges
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!