BUT when I try to run my script to create function index it's failed, Oracle 9.2.0.1 on Windows. As soon as I grant rewrite query to user it's fine and can create function index. -----Original Message----- From: Fuad Arshad [mailto:fuadar@xxxxxxxxx] Sent: Monday, July 26, 2004 1:08 PM To: oracle-l@xxxxxxxxxxxxx Subject: RE: Function Index no special privileges required on 9i Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning option JServer Release 9.2.0.4.0 - Production SQL> create user abc identified by abc; User created. SQL> grant create session to abc; Grant succeeded. SQL> grant create table to abc; Grant succeeded. SQL> alter user abc default tablespace users; User altered. SQL> grant unlimited tablespace to abc; Grant succeeded. SQL> connect abc/abc; Connected. SQL> create table abc (abc1 varchar2(100)); Table created. SQL> create index abc_index on abc (upper(abc1)); Index created. SQL> SQL> show parameter query NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ query_rewrite_enabled string FALSE query_rewrite_integrity string enforced SQL> Hamid Alavi <hamid.alavi@xxxxxxxxxxx> wrote: I am running on Oracle 9.2.0.1 on Windows but still without special = privs user can not create any function index! ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------