我把一个9206升级到1020之后,在客户端使用OEM就不能连接了,但是使用sqlplus可以连接。是怎么回事呢?报错是:您必须具有SELECT ANY DICTIONARY权限才能运行此应用程序,请要求DBA为您授予此权限。
我使用的是SYSTEM用户,发现此问题后又登陆SQLPLUS授权:
SQL> grant select any dictionary to system with admin option;
Grant succeeded
SQL> select * from dba_sys_privs where grantee='SYSTEM';
GRANTEE PRIVILEGE ADMIN_OPTION
------------------------------ ---------------------------------------- ------------
SYSTEM UNLIMITED TABLESPACE YES
SYSTEM CREATE TABLE NO
SYSTEM SELECT ANY DICTIONARY YES
SYSTEM GLOBAL QUERY REWRITE NO
SYSTEM CREATE MATERIALIZED VIEW NO
SYSTEM SELECT ANY TABLE NO
6 rows selected
我使用的是SYSTEM用户,发现此问题后又登陆SQLPLUS授权:
SQL> grant select any dictionary to system with admin option;
Grant succeeded
SQL> select * from dba_sys_privs where grantee='SYSTEM';
GRANTEE PRIVILEGE ADMIN_OPTION
------------------------------ ---------------------------------------- ------------
SYSTEM UNLIMITED TABLESPACE YES
SYSTEM CREATE TABLE NO
SYSTEM SELECT ANY DICTIONARY YES
SYSTEM GLOBAL QUERY REWRITE NO
SYSTEM CREATE MATERIALIZED VIEW NO
SYSTEM SELECT ANY TABLE NO
6 rows selected