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: Randy Harris <randy.harris_at_nospam.net>
Date: Wed, 26 Feb 2003 06:13:17 GMT
Message-ID: <1WY6a.1426$se1.1042894@newssvr28.news.prodigy.com>


That's what I needed - thanks! I didn't find CREATE INDEX in the list of permissions. I can't find GRANT CREATE INDEX in the 8i docs.

I tried:

GRANT CREATE INDEX ON TABLENAME TO USERNAME it tells me that is an invalid permission. Can you give me a sample?

--
Randy Harris



"Girish Mohata" <gmohata_at_yahoo.com> wrote in message
news:42a840c2.0302251955.70207e5e_at_posting.google.com...

> "Randy Harris" <randy.harris_at_nospam.net> wrote in message
news:<4he6a.1074$se1.738241_at_newssvr28.news.prodigy.com>...
> > 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
>
>
> GRANT CREATE INDEX to user (note, you must have DBA privileges or must
> be the owner of the table to grant this privilege)
Received on Wed Feb 26 2003 - 00:13:17 CST

Original text of this message

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