Database Administration (MOSC)

MOSC Banner

insufficient privileges from explain plain

edited Aug 28, 2018 12:51PM in Database Administration (MOSC) 9 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center