I get the error message "Insufficient Priveleges" when executing an explain plan. I checked and the schema that the plan table is created on has granted the select privelage to the schema that I am running the explain plan from. What privelages do I need to excecute an explain plan via PL/SQL Developer (F5)?
PLAN TABLE
- Thread starter soldado
- Start date
You will need select, insert and delete privileges on the PLAN_TABLE, and you will also need select privileges on the underlying tables and views of the query for which you want to get the query plan.
