安装了Oracle Rac 11g,并且解除了scott用户的锁定。使用scott登陆后,本想从远程查看一下v$instance,没想到报错:
table or view does not exist
查看一下scott的系统权限:
select * from dba_sys_privs where grantee='SCOTT';
注意用户名大写。结果:
GRANTEE PRIVILEGEADM
------------------------------ ---------------------------------------- ---
SCOTT UNLIMITED TABLESPACENO 没有访问数据字典的权限。授予:
SQL> grant SELECT ANY DICTIONARY to scott;
Grant succeeded. 再查看:
SQL> select * from dba_sys_privs where grantee='SCOTT';
GRANTEE PRIVILEGEADM
------------------------------ ---------------------------------------- ---
SCOTT SELECT ANY DICTIONARYNO
SCOTT UNLIMITED TABLESPACENO 再查询便可以了。
PS:查询用户有哪些角色可以用:
select * from dba_sys_privs where grantee='SCOTT'