Re: ORA-01031: insufficient privileges

From: Deke <Deke_at_nospam.com>
Date: Sun, 05 Jun 2005 10:06:14 -0400
Message-ID: <11a61mo8r0evi96@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. Received on Sun Jun 05 2005 - 09:06:14 CDT