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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Which Grant

Re: Which Grant

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Sun, 23 Feb 2003 17:31:00 -0800
Message-ID: <3E5975D4.8C51C9D4@exesolutions.com>


Randy Harris wrote:

> What permission do I need to grant to permit a user to create an index on a
> table? I thought that ALTER would work, but no.
>
> TIA
> Randy Harris

CREATE INDEX ... not ALTER TABLE.

http://tahiti.oracle.com

You need no grant to create index on tables that you own.

Daniel Morgan Received on Sun Feb 23 2003 - 19:31:00 CST

Original text of this message

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