Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
In Toad 11.6, get Ora-01031 error trying to connect to 12c database
설명
When connecting to an Oracle 12.1.0.2 database, using Toad 11.6.0.43, with a regular user, the following error message is received.
"Ora-01031 Insuficient priviliges"
After this The connection works ok.
When connecting to Oracle 10.2.0.4 database, with the same regular user, there is no error.
Both have all privileges to connect and resource.
원인
Oracle 12.1.0.2 changed some things in the data dictionary that are causing this. Specifically, the table SYS.USER$ is no longer included in the SELECT ANY DICTIONARY system privilege. So what's happening is that Toad is detecting that the user has SELECT ANY DICTIONARY, and assuming because of that, the user can select from the SYS.USER$ table.
해결 방안
RESOLUTION #1: Grant SYS.USER$ to the user.
RESOLUTION #2: Upgrade to the current version of Toad, which you can download here.
