在HR 用户下,执行查询语句是出现"Oracle动态执行表不可访问"
经查,是因为用户权限不够所致,修改scott用户权限语句如下:
grant select on V_$session to HR;
grant select on V_$sesstat to HR;
grant select on V_$statname to HR;
用sys用户登录,执行以上sql,成功即可。
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
本文作者:JOHN
ORACLE技术博客:ORACLE 猎人笔记 数据库技术群:367875324 (请备注ORACLE管理 )
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++