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: Deke <Deke_at_nospam.com>
Date: Sun, 05 Jun 2005 10:55:19 -0400
Message-ID: <11a64iohh4vq33c@news.supernews.com>


Fabrizio wrote:

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


This is it! I will get the 10G Enterprise Manager if it exists of Win XP. Received on Sun Jun 05 2005 - 09:55:19 CDT

Original text of this message

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