explain plan error ora-01039 insufficient privileges Eriline Kentucky

Address 117 Mountain Ave, Hazard, KY 41701
Phone (606) 439-4999
Website Link
Hours

explain plan error ora-01039 insufficient privileges Eriline, Kentucky

Re: Weird problem in explain plan 795181 Sep 1, 2010 12:26 PM (in response to Toon Koppelaars) Good answer, however it does not explain why the query works. The underlying objects (if you do not want to grant SELECT_CATALOG) are V_$SQL_PLAN, V_$SESSION and V_$SQL_PLAN_STATISTICS_ALL (with an underscore). Join our community for more solutions or to ask questions. How to tell why macOS thinks that a certificate is revoked?

This tool uses JavaScript and much of it will not work correctly without it enabled. TrackBack URI Leave a Reply Cancel reply Enter your comment here... Advanced Search Forum Oracle Forums Oracle Database Administration priviledge error explain plan If this is your first visit, be sure to check out the FAQ by clicking the link above. Thanks.

You may have to register before you can post: click the register link above to proceed. You have posted to a forum that requires a moderator to approve posts before they are publicly available. Maybe to test, try to grant "select any table" to the user who does the explan plan. All I can see is forum help.

The views and opinions expressed by visitors to this blog are theirs and do not necessarily reflect mine. Going to be away for 4 months, should we turn off the refrigerator or leave it on with water inside? Create an account to join the discussion. Exactly the question I was asked yesterday!

I found it. Enter your Username and Password to log in. Is there any job that can't be automated? Join & Ask a Question Need Help in Real-Time?

Near Earth vs Newtonian gravitational potential Truth in numbers Logical fallacy: X is bad, Y is worse, thus X is not bad Physically locating the server Is "halfly" a word? Comment by Doug Burns -- June 30, 2009 @ 12:37 pm Reply Thank you for visiting Doug Looks like Our friends have smilar minds🙂 What was your solution to the question The views expressed are my own and not those of past or current employers. This is important as you can't GRANT SELECT on a synonym, but only the underlying object. –Blama Apr 10 '15 at 9:13 add a comment| Your Answer draft saved draft

Replies Follow Rene / 24 Mar 2009 at 6:22pm Hi,Checkout the "Database Privileges" topic in the online help. Follow Alex Luk / 25 Mar 2009 at 3:25am Hi,The "ORA-01039: insufficient privileges on underlying objects of the view" message actually means that you don't have privileges to access the BASE As far as i know, in packages, procedures etc. asked 2 years ago viewed 3965 times active 1 year ago Related 25ORA-01031: insufficient privileges when selecting view3'ORA-01031: insufficient privileges' error received when inserting into a View1Insufficient privilege when creating a

In this article I'll describe what I did and share my script. Please help. SQL> create view v_exp_test as select * from exp_test; View created. Show 4 replies 1.

Using the DISPLAY_SQLSET Functionrequires the user to have the SELECT privilege on ALL_SQLSET_STATEMENTS and ALL_SQLSET_PLANS. This tool uses JavaScript and much of it will not work correctly without it enabled. Covered by US Patent. Why does the material for space elevators have to be really strong?

I just did explan plan for select * from user_users and got the same error. Get 1:1 Help Now Advertise Here Enjoyed your answer? Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list.

Re: Weird problem in explain plan Toon Koppelaars Sep 1, 2010 12:28 PM (in response to 795181) user4390399 wrote: Good answer, however it does not explain why the query works.Yes it You have posted to a forum that requires a moderator to approve posts before they are publicly available. Oracle needs your user explicitly granted to select on those objects, not through a role. SQL> create table exp_test as select * from user_objects where rownum<1000; Table created.

More discussions in PL/SQL and SQL All PlacesDatabaseDatabase Application DevelopmentPL/SQL and SQL This discussion is archived 4 Replies Latest reply on Sep 1, 2010 12:46 PM by 795181 Weird problem in If you want to explain plan your query you'll either require: - select any table privilege, or - explicit select privilege on USER_USERS and all of the underlying objects that the Another guess ( which is more probable ) is that, some tables used in the view are granted to some role and you have that role. Database Journal | SQLCourse | SQLCourse2 Register Help Remember Me?

Check PLUSTRACE role is enabled SP2-0611: Error enabling STATISTICS report and SQL> set autotrace traceonly explain SQL> select * from cat; Execution Plan ---------------------------------------------------------- ERROR: ORA-01039: insufficient privileges on underlying objects Mark all read Contact Us · · Top Generated in 0.008 seconds in which 0.001 seconds were spent on a total of 3 queries. Maybe to test, try to grant "select any table" to the user who does the explan Go to Solution 3 Comments LVL 10 Overall: Level 10 Oracle Database 9 Message Results 1 to 2 of 2 Thread: ORA-01039: insufficient privileges on underlying objects of the view Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear

SQL> grant execute on explain_it to read_only; Grant succeeded. ----connect with read_only SQL> connect read_only/read_only Connected. Join them; it only takes a minute: Sign up SQL Error: ORA-01039: insufficient privileges on underlying objects of the view up vote 2 down vote favorite I am trying to get Create an account to join the discussion. I have the same question Show 0 Likes(0) 1213Views Tags: none (add) 11gContent tagged with 11g, developerContent tagged with developer, explainContent tagged with explain, planContent tagged with plan, sqlContent tagged with

Like Show 0 Likes(0) Actions 4. For explain plan you'll need direct grants (not via a role), or select any table... (just what I said). Comment by Asif Momen -- June 30, 2009 @ 3:36 pm Reply RSS feed for comments on this post. All rights reserved.

Code: Logon the SQL*PLUS as USER SYS SQL> CONNECT sys/password Execute the plustrce.sql script SQL> @$ORACLE_HOME/sqlplus/admin/plustrce.sql Grant Role PLUSTRACE to User SQL> GRANT plustrace TO username; Logon as the user requiring Reply With Quote 12-06-2002,10:57 AM #3 ayushsingh View Profile View Forum Posts Junior Member Join Date Dec 2002 Posts 62 Thanks for the reply after doing the above I get these SQL> select count(*) from hr.v_exp_test; COUNT(*) ---------- 156 SQL> explain plan for select count(*) from hr.v_exp_test; explain plan for select count(*) from hr.v_exp_test * ERROR at line 1: ORA-01039: insufficient privileges Follow ryanp / 24 Mar 2009 at 7:13pm Hello Rene,I'm having a difficulty to find "online help" link.

In any case, I have DBA permissions for the server.That's a role.... Please type your message and try again. also check out with utlxplan.sql to know the name of tables/views/packages which you need accss for vieing th plan table. 0 Write Comment First Name Please enter a first name Last Results 1 to 3 of 3 Thread: priviledge error explain plan Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode

Or like I posted before, try it with sys or system. 0 LVL 11 Overall: Level 11 Oracle Database 9 Message Expert Comment by:sujit_kumar2005-01-05 See if you have h Slect