Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01039 on attempt to perform EXPLAIN PLAN

392830Mar 31 2006 — edited Apr 3 2006

Folks,

I'm running a query below on Ora10G and getting "ORA-01039: insufficient privileges on underlying objects of the view":

EXPLAIN PLAN INTO DBO.plan_table FOR SELECT last_analyzed FROM all_tables WHERE table_name='MyTable'

I'm running under a user TST account and I did "grant all privileges to TST" to make sure I did not forget any privileges. This did not help. I also tried to explicitly "grant insert on plan_table to TST" and "grant select on all_users to TST" but that did not help either. What am I doing wrong?

Thanks,
Vladimir.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 1 2006

Added on Mar 31 2006

#general-database-discussions

3 comments

1,674 views