Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Function based index

Re: Function based index

From: Doeni <doeni_at_evhr.net>
Date: 26 Oct 1999 21:56:02 +0200
Message-ID: <87d7u1galp.fsf@freebie.evhr.net>


The user also needs to have 'QUERY REWRITE' privilege granted. It is missing in the manuals.

leorajan_at_my-deja.com writes:

> Hi all,
> I am trying to create a function based index on a table. I am getting
> Insufficient privileges error. I do have CREATE ANY INDEX privilege. I
> just want to know what is the basic privileges needed to create a
> function based index?
> Please help me on this.
>
> Thanks
> Leo.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

--
The fundamental aim of King Crimson is to organize anarchy, to utilize

   the latent power of chaos and to allow the varying influences to

	       interact and find their own equilibrium.
                                        -Robert Fripp
Received on Tue Oct 26 1999 - 14:56:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US