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: problems installing the Designer 6i repository

Re: problems installing the Designer 6i repository

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 07 Aug 2001 19:10:27 +0100
Message-ID: <3B702F13.1434@yahoo.com>

Rob Oonk wrote:
>
> Hi
>
> once again an effort to get a response to my problem:
>
> after a successfull installation of Oracle 8i enterprise edition and
> Designer 6i
> I created a user with sufficient priviliges (i've checked the requirements)
> to install the Designer repository.
>
> Nevertheless, when I hit the button to start the repository-install i get
> the following message:
> - You do not have Select privilege on SYS.V_$PARAMETERS view. The process
> cannot proceed -
>
> Logically i logged in as SYS and tried to grant the selectprivilege to the
> user, but this view does not exist, neither
> does SYS.V$PARAMETERS, so there's nothing to grant !!
>
> The nearest views in name are: SYS.V_$PARAMETER (without the S) and
> SYS.V_$PARAMETER2
>
> I already got 3 answers in the past that didn't work:
> 1. check the spelling ( so I did )
> 2. log in as SYS and grant the privilege to the designerowner (i wanted
> to, but the view doesn't exists, so...)
> 3. log in as SYS and create the view (i don't think that's an option
> ( )
>
> I would be very grateful if someone could solve this mystery for me, because
> i cannot imagine i'm the only one
> who has or had this problem !
>
> Rob

Documentation bug - its SYS.V_$PARAMETER (not plural)...

Alternatively, you can be lazy and give the repository owner "select any table"

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."
Received on Tue Aug 07 2001 - 13:10:27 CDT

Original text of this message

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