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博客 ” ，链接：http://blog.itpub.net/19015/viewspace-911404/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/19015/viewspace-911404/