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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Aarrrggghhh!!! Creating an index shouldn't be so hard!

Re: Aarrrggghhh!!! Creating an index shouldn't be so hard!

From: Binley Lim <binley.lim002_at_winz.govt.nz>
Date: Thu, 05 Oct 2000 12:32:17 +1200
Message-Id: <10639.118541@fatcity.com>


grant query rewrite to sysop;

Dennis Taylor wrote:
>
> At 02:49 PM 10/4/00 -0700, you wrote:
> >>>>
> RE: Aarrrggghhh!!! Creating an index shouldn't be so hard!
>
> grant CREATE INDEX to sysop
>
> <<<<
>
> SQL>
> SQL> show user
> USER is "SYS"
> SQL> grant create index to sysop;
> grant create index to sysop
> *
> ERROR at line 1:
> ORA-00990: missing or invalid privilege
>
> ---
> Dennis Taylor
Received on Wed Oct 04 2000 - 19:32:17 CDT

Original text of this message

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