Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01031: insufficient privileges

Re: ORA-01031: insufficient privileges

From: Randy Harris <randy_at_SpamFree.com>
Date: Sun, 05 Jun 2005 14:44:02 GMT
Message-ID: <ScEoe.42$jS1.4@newssvr17.news.prodigy.com>

"Deke" <Deke_at_nospam.com> wrote in message news:11a61mo8r0evi96_at_news.supernews.com...
> fitzjarrell_at_cox.net wrote:
> >
> > Deke wrote:
> >
>
> >>Roles granted:
> >>AQ_ADMINISTRATOR_ROLE
> >>CONNECT
> >>DBA
> >>MGMT_USER
> >>RESOURCE
> >>
> >>System Privs:
> >>CREATE MATERIALIZED VIEW
> >>CREATE TABLE
> >>GLOBAL QUERY REWRITE
> >>SELECT ANY DICTIONARY
> >>SELECT ANY TABLE
> >>UNLIMITED TABLESPACE
> >
> >
> > The problem lies in trying to connect to the SYSTEM account as either
> > SYSDBA or SYSOPER, I suspect. Try using the 'Normal' option; you will
> > probably find your connection succeeds error-free.
> >
>
> If you login as normal and SYSTEM then it says I need the SELECT ANY
> DICTIONARY priv. But I already have that if you see above.

Perhaps if you post what it is you are trying to do and what problem you are having someone might be able to assist. Until now you've provided so little information that you are forcing people to guess what the problem might be. Received on Sun Jun 05 2005 - 09:44:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US