物化视图权限总结

纪念2013年展望2014年新的突破，新的进步！

建立物化视图的选项很多，如果在建立物化视图的时候由于缺少权限而报错，ORACLE给出的错误信息仅仅是ORA-01031: 权限不足，而没有清楚的给出是由于缺少哪种权限造成的。
SQL> create user test identified by test;

User created.

SQL>  GRANT CREATE SESSION TO TEST;

Grant succeeded.

SQL> SQL> GRANT UNLIMITED TABLESPACE TO TEST;

Grant succeeded.

SQL> grant create table to test;

Grant succeeded.

第一种权限不足，在自己的属主下创建普通物化视图
SQL> conn test/test
Connected.
SQL> CREATE TABLE T (ID NUMBER PRIMARY KEY, NAME VARCHAR2(30));

Table created.

SQL> CREATE MATERIALIZED VIEW MV_T AS SELECT * FROM T;
CREATE MATERIALIZED VIEW MV_T AS SELECT * FROM T
                                               *
ERROR at line 1:
ORA-01031: insufficient privileges

SQL> show user   
USER is "SYS"
SQL> grant CREATE M