Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Aarrrggghhh!!! Creating an index shouldn't be so hard!
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
![]() |
![]() |