SQL Optimizer : ora 00942 Invalid SQL Statment (4330088)

You may encounter an error message while using the SQL Optimizer "Invalid sql statment ORA:00942"

If you are not a DBA, to be able to analyze SQL statements, execution plans and optimize SQL statements you only need 2 privileges:

/ * Grant execute on SYS.DBMS_SQL package. Used to execute SQL and retrieve run time. */

GRANT EXECUTE ON SYS.DBMS_SQL TO <user>;

/* Create table privilege on user's schema. The first time you log onto the product, it automatically creates the plan table that it is used to temporarily obtain the execution plan information from Oracle. Workaround: If you don't have the create table privilege, a user with this privilege can create the plan for you. A script to create this plan table is provided so that someone with the create table privilege can create the table for you */

GRANT CREATE TABLE TO <user>;

This will get rid of the error message.