| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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))
*
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).Received on Mon Aug 05 2002 - 11:38:23 CDT
 |
 |