Re: ORA-01031: insufficient privileges

From: <fitzjarrell_at_cox.net>
Date: 4 Jun 2005 20:07:54 -0700
Message-ID: <1117940874.469309.322610@g43g2000cwa.googlegroups.com>

Deke wrote:
> IANAL_VISTA wrote:
> > Deke <Deke_at_nospam.com> wrote in news:11a4lts9mm7tvcc_at_news.supernews.com:
> >
> >
> >>I get ORA-01031: insufficient privileges when connecting as system onto
> >>an Oracle 10G database on Sun Solaris 9 using Enterprise manager on a
> >>Windows Xp PC and get the following error:
> >>
> >>ORA-01031: insufficient privileges.
> >>
> >>How do I solve this problem?
> >>
> >>Thanks
> >>
> >
> >
> > Be GRANTed sufficient privs (like CONNECT).
>
>
> 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.

David Fitzjarrell Received on Sat Jun 04 2005 - 22:07:54 CDT