ORA-01039

Execution Plan
----------------------------------------------------------
ERROR:
ORA-01039: insufficient privileges on underlying objects of the view

SP2-0612: Error generating AUTOTRACE EXPLAIN report
解决方法:
SQL> show user
USER 为 "SYS"
SQL> grant select any dictionary to scott;
授权成功。
scott用户再次登录
set autot on
不再报错。

 

posted @ 2014-06-30 17:44  ArcerZhang  阅读(843)  评论(0编辑  收藏  举报