RE: Function Index

  • From: Bob Lofstrand <blofstrand@xxxxxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 26 Jul 2004 14:02:16 -0500

grant query rewrite

-----Original Message-----
From: Hamid Alavi [mailto:hamid.alavi@xxxxxxxxxxx]
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@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
-----------------------------------------------------------------


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@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
-----------------------------------------------------------------

Other related posts: