EXPLAIN PLAN and ORA-01039: insufficient privileges on underlying objects of the view
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.