Btw, this is no longer the case starting from 9i, you don't need any special privileges for creating & using function based indexes. Tanel. ----- Original Message ----- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx> > 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. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------