TOAD与Oracle DB 12c

最新推荐文章于 2022-01-20 11:44:56 发布

转载最新推荐文章于 2022-01-20 11:44:56 发布 · 1k 阅读

文章标签：

#toad #oracle #12c #oracle #12.2

Oracle DB 专栏收录该内容

772 篇文章

订阅专栏

本文介绍了解决使用Toad连接Oracle 12c数据库时出现的ORA-01031错误的方法。该错误源于Oracle 12c中增强了安全性，限制了对SYS.USER$等系统表的访问。解决方案是为相关用户授予对SYS.USER$表的SELECT权限。

ORA-01031 When Connecting To A 12c Database With Toad (文档 ID 1958777.1)

SOLUTION

Access to SYS.USER$ has been restricted in Oracle 12c (as documented here)

The issue can be resolved by granting access to the SYS.USER$ table to the relevant account:

GRANT SELECT ON SYS.USER$ TO <user>;

For further assistance, please contact the software vendor as this is specific to Toad (not Oracle)

另注:这其实是Oracle 12c的一个特性:

(https://docs.oracle.com/database/121/DBSEG/release_changes.htm#DBSEG000)
SELECT ANY DICTIONARY Privilege No Longer Accesses Some SYS Data Dictionary Tables

For better security, the SELECT ANY DICTIONARY system privilege no longer permits you to query the SYS schema system tablesDEFAULT_PWD$, ENC$, LINK$, USER$, USER_HISTORY$, CDB_LOCAL_ADMINAUTH$, and XS$VERIFIERS. Only user SYS has access to these tables, but user SYS can grant object privileges (such as GRANT SELECT ON USER$ TO sec_admin) to other users.