RE: Insufficient privileges

Which version of the database?

> -----Original Message-----
> From: Babu.Nagarajan_at_Cummins.com [mailto:Babu.Nagarajan_at_Cummins.com]
> Sent: Monday, August 05, 2002 12:38 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Insufficient privileges
>
>
>
> Oracle needs it even to create the index
>
> Babu
>
> A03D817 > create user test identified by test default
> tablespace users temporary tablespace temp;
> User created.
>
> A03D817 > grant resource, connect to test;
> Grant succeeded.
>
> A03D817 > conn test/test_at_a03d817
> Connected.
> A03D817 > create table test (testnum number);
> Table created.
>
> A03D817 > insert into test values (1);
> 1 row created.
>
> A03D817 > insert into test values (2);
> 1 row created.
>
> A03D817 > commit;
> Commit complete.
>
> A03D817 > create index fbidx on test(to_char(testnum));
> create index fbidx on test(to_char(testnum))
> *
> ERROR at line 1:
> ORA-01031: insufficient privileges
>
> A03D817 > conn cl044_at_a03d817
> Enter password: *******
> Connected.
>
> A03D817 > grant query rewrite to test;
> Grant succeeded.
>
> A03D817 > conn test/test_at_a03d817
> Connected.
>
> A03D817 > create index fbidx on test(to_char(testnum));
> Index created.
>
>
>
>
>
> "Gogala, Mladen" <MGogala_at_oxhp.com>@fatcity.com on 08/05/2002
> 10:20:22 AM
>
> Please respond to ORACLE-L_at_fatcity.com
>
> Sent by: root_at_fatcity.com
>
>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> cc:
>
>
>
> 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: Babu.Nagarajan_at_Cummins.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).