给scott用户解锁
alter user scott account unlock
关于Oracle错误:动态执行表不可访问,本会话自动统计被禁止,关闭自动统计之后的问题
sqlplus /nolog 进入登录页面,然后执行conn /as sysdba 登录到sys用户
用SYS登录,授权给相应的用户,用下面的语句
grant select on v_$statname to scott;
grant select on v_$sesstat to scott;
grant select on v_$session to scott;
grant select on v_$mystat to scott;
取消权限
revoke select on v_$statname from scott;
revoke select on v_$sesstat from scott;
revoke select on v_$session from scott;
revoke select on v_$mystat from scott;
alter user scott account unlock
关于Oracle错误:动态执行表不可访问,本会话自动统计被禁止,关闭自动统计之后的问题
sqlplus /nolog 进入登录页面,然后执行conn /as sysdba 登录到sys用户
用SYS登录,授权给相应的用户,用下面的语句
grant select on v_$statname to scott;
grant select on v_$sesstat to scott;
grant select on v_$session to scott;
grant select on v_$mystat to scott;
取消权限
revoke select on v_$statname from scott;
revoke select on v_$sesstat from scott;
revoke select on v_$session from scott;
revoke select on v_$mystat from scott;