From oracle-l-bounce@freelists.org Mon Jul 26 15:35:07 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6QKYdu00436 for ; Mon, 26 Jul 2004 15:34:50 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i6QKYT600325 for ; Mon, 26 Jul 2004 15:34:39 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4883472DC0A; Mon, 26 Jul 2004 15:11:41 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01669-27; Mon, 26 Jul 2004 15:11:41 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 42DA772D415; Mon, 26 Jul 2004 15:11:37 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 26 Jul 2004 15:09:54 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6787272DB56 for ; Mon, 26 Jul 2004 15:09:53 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01196-10 for ; Mon, 26 Jul 2004 15:09:53 -0500 (EST) Received: from ftp.bluelineresults.com (unknown [216.222.6.52]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 853A672CB97 for ; Mon, 26 Jul 2004 15:09:51 -0500 (EST) Received: (qmail 6108 invoked by uid 0); 26 Jul 2004 20:29:37 -0000 Received: from justin@askddbc.com by em by uid 11186 with qmail-scanner-1.20 (clamscan: 0.60. Clear:RC:1(192.168.5.15):. Processed in 0.422269 secs); 26 Jul 2004 20:29:37 -0000 Received: from unknown (HELO terminal) ([192.168.5.15]) (envelope-sender ) by 0 (qmail-ldap-1.03) with SMTP for ; 26 Jul 2004 20:29:33 -0000 From: "Justin Cave" To: Subject: RE: Function Index Date: Mon, 26 Jul 2004 14:33:48 -0600 MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-Mailer: Microsoft Office Outlook, Build 11.0.5510 Thread-Index: AcRzT2GjDK0ss/rlRJ6ZCilUt3UasQAADCZQ In-Reply-To: <000101c4734f$61a37750$0a05a8c0@ddbc.local> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181 X-Qmail-Scanner-Message-ID: <10908737766546104@em> Message-Id: <20040726200951.853A672CB97@turing.freelists.org> X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 6054 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: justin@askddbc.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Fuad Arshad Sent: Monday, July 26, 2004 2:30 PM To: oracle-l@freelists.org 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 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@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------