Re: Priveleges for EXPLAIN PLAN

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Wed, 26 May 1999 19:58:34 GMT
Message-ID: <37524d28.21961481@netnews.worldnet.att.net>

On Tue, 25 May 1999 10:54:40 +0200, "Allen Worthington" <wor_at_my-dejanews.com> wrote:

>Can anyone tell a newbie what the *minimum* required privileges are in order
>to be able to execute EXPLAIN PLAN?

I don't believe that you need any special privileges. You probably need SELECT access to the tables that you are querying. You also need a plan table. You will need CREATE TABLE in order to create that.

BTW, to create the plan table on UNIX:

        SQL>@$ORACLE_HOME/rdbms/admin/utlxplan

on NT:

        SQL>c:/orant/rdbms80/admin/utlxplan

On NT, the exact path may vary depending on whether you have Oracle8, Oracle8i, or Oracle7 installed.

        regards,

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are Received on Wed May 26 1999 - 14:58:34 CDT