Re: required select grant on non-existing sys.view !

"Rob" <rob_at_fcs.dhs.org> wrote in message news:9ju3p3$t41$1_at_scavenger.euro.net...
> hi,
> i've just installed Designer 6i.
> When i try to install the repository the program comes up with the next
> message: - You do not have Select privilege on sys.V_$PARAMETRS view. The
> process cannot proceed -
>
> When i checked the requirements for installing the repository, all needed
> grants are there, but
> i did notice though there is no such view as sys.V_$PARAMETRS !!!
>
> Can anyone help with this. Is it a bug or what ?
>
> Thanx in advance (as always :))
> Rob
>
>

It is not a bug, it is a feature.
All v$ object you usually select from are synonyms on views in SYS. v$session is a synonym for v_$session and so on. So...
You need to connect as SYS, and grant select priv on v_$parameters to the designer owner.
You currently have access thru a role and you need direct access.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Sat Jul 28 2001 - 14:55:22 CEST