Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Function Index
Btw, this is no longer the case starting from 9i, you don't need any special
privileges for creating & using function based indexes.
Tanel.
> revoke create any indextype from user;
> grant query rewrite to user;
>
>
> Also, make sure query_rewrite_enabled=3Dtrue and
> query_rewrite_integrity=3Dtrusted or the index may not be used.
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Mon Jul 26 2004 - 13:49:56 CDT
![]() |
![]() |