Re: ORA-01031: insufficient privileges

"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