create view failed with ORA-01031: insufficient privileges
情景：想在system下创建视图，其中引用另外一个用户的表，创建时报错ORA-01031: insufficient privileges
解决过程如下：
[@more@]
SQL> show user
USER is "SYSTEM"
SQL> create view v_haocp as select count(1) FROM tmsfzwf.t_workitem;
create view v_haocp as select count(1) FROM tmsfzwf.t_workitem
*
ERROR at line 1:
ORA-01031: insufficient privileges
SQL> select count(1) FROM tmsfzwf.t_workitem;
COUNT(1)
----------
0
虽然查询权限有了，但是创建视图还要有update insert 和delete 权限，如果这些权限没有赋予的话，视图创建不了。
付权操作：
grant select, delete, insert, update on tmsfzwf.t_workitem to system;
SQL> create view v_haocp as select count(1) FROM tmsfzwf.t_workitem;
view created.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/19015/viewspace-911404/ ，如需转载，请注明出处，否则将追究法律责任。
