Print Friendly, PDF & Email

 
ISSUE

A user cannot connect to Oracle Database 12c with Toad. He gets ORA-01031: insufficient privileges every time when attempting to connect.

 
REASON

In 12c release an access to SYS.USER$ table has been restricted.

 
SOLUTION

The issue only related to TOAD of v11.6 only. A newer version of TOAD won’t throw the error.
To fix the issue just grant access to the SYS.USER$ to the relevant account

GRANT SELECT ON SYS.USER$ TO "account_name";

 
REFERENCES

ORA-01031 occurs when connecting to Oracle 12c with Toad 11.6
ORA-01031 When Connecting To A 12c Database With Toad (Doc ID 1958777.1)

Increased Security When Using SELECT ANY DICTIONARY
SELECT ANY DICTIONARY Privilege No Longer Accesses Some SYS Data Dictionary Tables

 
 

Version  : 12:39 14.03.2018
Database : Oracle database 12.2.0.1.0