Database Administration (MOSC)

MOSC Banner

EXPLAIN PLAN and ORA-01039: insufficient privileges on underlying objects of the view

edited Feb 12, 2018 4:00AM in Database Administration (MOSC) 4 commentsAnswered

Hi folks.

I`ve been trying to run EXPLAIN PLAN for select * from sample_view

but get error ORA-01039 error.

sample_view consists select on table which user isn`t granted directly (only  schema has this grant with GRANT option)

select * from sample_schema executes without error.

When I grant select any table system privilege then error disappears. But this is not correct solution.

Do you know a minimal list of system views that require for explain plan?

BTW: I`m able to EXPLAIN PLAN for tables which granted directly to user.

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