Re: ORA-01031: insufficient privileges

From: Fabrizio <fabrizio.magni_at_mycontinent.com>
Date: Sun, 05 Jun 2005 14:38:01 GMT
Message-ID: <d7Eoe.983857$b5.42728582@news3.tin.it>

Deke wrote:

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

Are you connecting from a 9i enterprise manager to a 10g database?

Because that's the typical error you'll get.

Regards

-- 
Fabrizio Magni

fabrizio.magni_at_mycontinent.com

replace mycontinent with europe

Received on Sun Jun 05 2005 - 09:38:01 CDT