insufficient privileges from explain plain
I need help!
A user needs to run an explain plan from a table but is not working.
The user executes the select * from table, but he doesn´t get to run the explain plan.
The select "select * from org" is working.
select * from org;
So, I created a plan table to the schema of the table, but it is not working.
SQL> EXPLAIN PLAN set STATEMENT_ID='test' FOR
select * from org
2 3
SQL> /
select * from org
*
ERROR at line 2:
ORA-01031: insufficient privileges
Which privileges do I need to grant?
a
Thanks, juduque