Very odd... That's not what I see on my 9i box. Though I do have a different patchset than you. Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production SQL> create user abc identified by abc 2 ; User created. SQL> grant create session, create table to abc; Grant succeeded. SQL> alter user abc default tablespace users; User altered. SQL> grant unlimited tablespace to abc; Grant succeeded. SQL> conn abc/abc Connected. SQL> create table x ( col1 VARCHAR2(100) ); Table created. SQL> create index x_idx on x( UPPER( col1 ) ); create index x_idx on x( UPPER( col1 ) ) * ERROR at line 1: ORA-01031: insufficient privileges SQL> conn sys as sysdba Enter password: ****** Connected. SQL> grant query rewrite to abc; Grant succeeded. SQL> conn abc/abc Connected. SQL> create index x_idx on x( UPPER( col1 ) ); Index created. Justin Cave Distributed Database Consulting, Inc. http://www.ddbcinc.com/askDDBC -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Fuad Arshad Sent: Monday, July 26, 2004 2:30 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 -----------------------------------------------------------------