Skip to Main Content
  • Questions
  • How to grant a execute plan privilege to a user

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, ezio.

Asked: December 29, 2015 - 1:38 am UTC

Last updated: January 01, 2016 - 2:56 am UTC

Version: 9i

Viewed 10K+ times! This question is

You Asked

Hi :
I want to grant a user the execution plan privilege,But do not want grant his create table privilege,So what can i do ?
Thanks..

and Connor said...

From the docs:

"Prerequisites

To issue an EXPLAIN PLAN statement, you must have the privileges necessary to insert rows into an existing output table that you specify to hold the execution plan.

You must also have the privileges necessary to execute the SQL statement for which you are determining the execution plan. If the SQL statement accesses a view, then you must have privileges to access any tables and views on which the view is based. If the view is based on another view that is based on a table, then you must have privileges to access both the other view and its underlying table."

So make sure there is a PLAN_TABLE they can insert into, and make sure they have SELECT on the tables the queries will be on.

Hope this helps.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

link please?

Rajeshwaran, Jeyabal, December 30, 2015 - 11:50 am UTC

In addition to this bunch of text, please provide the link to docs. so that we can go through the link in case of additional/more details. Thanks.