RE: Insufficient privileges

Mladen,

You're *obviously* not an OCP, or you would have known this.

Jared
Orace Cretanfied Professional
and a bit daft

"Gogala, Mladen" <MGogala_at_oxhp.com>
Sent by: root_at_fatcity.com
08/05/2002 08:20 AM
Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        RE: Insufficient privileges

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
>
> ----- Original Message -----
> Date: Sun, 04 Aug 2002 22:58:39 -0800
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>
>
> > What is needed for simple users? Obviously a manual in
> which they could
> > read how to do the following:
> > $ sqlplus scott/tiger
> >
> > SQL*Plus: Release 9.2.0.1.0 - Production on Mon Aug 5 01:50:53 2002
> >
> > Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
> >
> >
> > Connected to:
> > Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
> > With the Partitioning and OLAP options
> > JServer Release 9.2.0.1.0 - Production
> >
> > SQL> grant index on emp to ops$mgogala;
> >
> > Grant succeeded.
> >
> > SQL> connect /
> > Connected.
> > SQL> grant create any index to scott;
> >
> > Grant succeeded.
> >
> > SQL>
> >
> >
> > On 2002.08.05 02:03 Edouard Dormidontov wrote:
> > > Hello World!
> > >
> > > User with role "connect" and "resource" attempted to
> create functional
> > > based index on his table, but received error "insufficient
> > > privileges".
> > > Users "SYS" or "SYSTEM" can create this type indexes.
> > > What is needed for simple users?
> > >
> > > Thank you.
> > >
> >
> > --
> > Mladen Gogala
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Mladen Gogala
> > INET: mgogala_at_adelphia.net
> >
> > 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).
> >
>
> --
> __________________________________________________________
> Sign-up for your own FREE Personalized E-mail at Mail.com
> http://www.mail.com/?sr=signup
>
> Get 4 DVDs for $.49 cents! plus shipping & processing. Click to join.
> http://adfarm.mediaplex.com/ad/ck/990-1736-3566-59
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rajesh Dayal
> INET: rdayal73_at_techie.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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: MGogala_at_oxhp.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).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Jared.Still_at_radisys.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).