From oracle-l-bounce@freelists.org Mon Jul 26 13:59:25 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6QIx0x00821 for ; Mon, 26 Jul 2004 13:59:10 -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 i6QIwo600666 for ; Mon, 26 Jul 2004 13:59:00 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BECC572CDD2; Mon, 26 Jul 2004 13:36:50 -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 13945-35; Mon, 26 Jul 2004 13:36:50 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 64D3B72D7D1; Mon, 26 Jul 2004 13:35:44 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 26 Jul 2004 13:33:59 -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 6102372D757 for ; Mon, 26 Jul 2004 13:33:57 -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 12487-77 for ; Mon, 26 Jul 2004 13:33:56 -0500 (EST) Received: from smtp1.corpsys.csedge.com (unknown [12.28.86.143]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 814D672D758 for ; Mon, 26 Jul 2004 13:33:18 -0500 (EST) Received: from CSMAIL.corpsys.csedge.com ([172.21.100.103]) by smtp1.corpsys.csedge.com with InterScan Messaging Security Suite; Mon, 26 Jul 2004 14:02:17 -0500 Received: by csmail.corpsys.csedge.com with Internet Mail Service (5.5.2657.72) id ; Mon, 26 Jul 2004 14:02:17 -0500 Message-ID: <0C3690346404A94CBF4DDDD4724FC61411E8F37D@csmail.corpsys.csedge.com> From: Bob Lofstrand To: "'oracle-l@freelists.org'" Subject: RE: Function Index Date: Mon, 26 Jul 2004 14:02:16 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-type: text/plain X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 6043 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: blofstrand@csedge.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org grant query rewrite -----Original Message----- From: Hamid Alavi [mailto:hamid.alavi@quovadx.com] Sent: Monday, July 26, 2004 1:49 PM To: 'Oracle-L (E-mail) Subject: Function Index List, For creating function index I have Granted "create any indextype" to user BUT still this user can not create Function Index. What kind of Privilege user need to create function index, I don't want to give DBA privs . Any idea? Thanks, ---------------------------------------------------------------- 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 ----------------------------------------------------------------- The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. ---------------------------------------------------------------- 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 -----------------------------------------------------------------