ORA-01031: insufficient privileges when Toad 11.6 connect to an Oracle 12c database

ORA-01031 When Connecting To 12c Database With Toad

When attempting to connect via Toad 11.6 to an Oracle 12c database, create any table, create any script, show any view, any scritp that time  toad application  through very annoying message “ORA-01031: insufficient privileges”

For any kind of change in database give

 ORA-01031: insufficient privileges

clicking  “OK ” in Toad, it looks  to connect to the database but not working anything  . just come a screen and still nothing show  

The ora-error code ORA-01031   only happens when using Toad 11.6 version . It does not occur in SQL*Plus, oracle SQL Developer or any other versions of Toad.

Solution

Access to SYS.USER$ has been restricted in Oracle 12c (for oracle 12c  security , role, privilege, references doc  https://docs.oracle.com/database/121/DBSEG/E48135-19.pdf)

The issue can be resolved by granting access to the SYS.USER$ table to the related user /schemas:

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

For grant the privilege login as sys dba

Sqlplus sys/sys_password@orcl  as sysdba

SQL> GRANT SELECT ON SYS.USER$ TO <user_name>;

Grant succeeded.

Reference Oracle Doc ID 1958777.1)