Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Which Grant
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...Received on Wed Feb 26 2003 - 00:13:17 CST
> "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)