Print Friendly, PDF & Email


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


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


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";


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