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).