ORA-01031 OCCURS WHEN CONNECTING TO ORACLE 12C WITH TOAD 11.6
A user cannot connect to Oracle Database 12c with Toad 11.6. He gets ORA-01031: insufficient privileges when connecting.
Access to SYS.USER$ has been restricted in Oracle 12c
For better security, the SELECT ANY DICTIONARY system privilege no longer permits you to query the SYS schema system tables DEFAULT_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.
The issue is related to the TOAD of v11.6 only. A newer version of TOAD won’t throw the error. To fix the issue, grant access to the SYS.USER$ to the relevant account.
GRANT SELECT ON SYS.USER$ TO "ACCOUNT_NAME";
ORA-01031 When Connecting To A 12c Database With Toad (Doc ID 1958777.1)
- Bash Scripts
- Default Category
- Directory Objects
- Environment Variables
- Initialization Parameters
- Memory Usage
- Metadata API
- NLS Settings
- Oracle Database
- Oracle Enterprise Manager
- Performance Tunning
- Red Hat Enterprise Linux
- Redo Logs
- Wait Events