RE: Insufficient privileges

That's the problem with irony. You have to use it so carefully. ; ) You may not have hit this problem if you were creating function-based indexes from a DBA-privileged account.

Per Chapter 21 in the Oracle8i Concepts manual, the following must be true for function-based indexes:

  To create a function-based index:

    The following initialization parameters must be defined:     QUERY_REWRITE_INTEGRITY must be set to TRUSTED     QUERY_REWRITE_ENABLED must be set to TRUE     COMPATIBLE must be set to 8.1.0.0.0 or a greater value

    The user must be granted CREATE INDEX and QUERY REWRITE, or CREATE ANY INDEX
    and GLOBAL QUERY REWRITE.

Regards,
Mike Hately
OCP Oracle 7.3, 8, 8i, 9i

-----Original Message-----
Sent: 05 August 2002 16:20
To: Multiple recipients of list ORACLE-L

Why would he need query rewrite to create an index? I'm NOT an OCP so please forgive me my ignorance. I, in my blissful ignorance, have thought that
query rewrite is for USING functional indexes and materialized views, not for CREATING them on another user's objects.

> -----Original Message-----
> From: Rajesh Dayal [mailto:rdayal73_at_techie.com]
> Sent: Monday, August 05, 2002 4:39 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Insufficient privileges
>
>
> You need to grant query rewrite privilege to the user e.g.
>
> SQL> grant query rewrite to scott ;
>
> once you do this the "simple user" should be able to create FBIs.
>
> HTH,
> Rajesh
> Senior Oracle DBA
> OCP Oracle 8,8i,9i
 

This email and any attached to it are confidential and intended only for the individual or
entity to which it is addressed. If you are not the intended recipient, please let us know
by telephoning or emailing the sender. You should also delete the email and any attachment
from your systems and should not copy the email or any attachment or disclose their content
to any other person or entity. The views expressed here are not necessarily those of
Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England.
Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hately Mike
  INET: Mike.Hately_at_churchill.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).