java.sql.SQLException: ORA-00942: table or view does not exist

ORA-00942 error while I was trying to connect a database schema/user using Oracle JDBC/thin client/Apache Tomcat/JSP/Java.
It got fixed after I granted the SELECT ANY DICTIONARY privilege to that user.
SQL> grant SELECT ANY DICTIONARY to scott;
Grant succeeded.
Now test your connection after granting the privilege, It should work without issue.
  • September 21, 2018 | 24 views
  • Comments