Re: Repository/Priveledges Problem

I just heard form Oracle support today that the 6i repository is NOT certified against 9i and they recommend against using it.

Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message news:9u5vvh$u8n$1_at_news6.svr.pol.co.uk...
>
> It might be related to 9i not letting people see SYS objects even if they
> have 'select any'. There is a new role 'select_dictionary_role' which
> allows this I think. Alternativelym a direct grant from sys to the
> repository user may do the trick,
>
> hth
> connor
>
> "Graeme Barnett" <graeme.barnett_at_unn.ac.uk> wrote in message
> news:9u4v4h$6ba$1_at_dax.unn.ac.uk...
> > I'm installing a repository and creating a user with priviledges.
> > I'm trying to create a select priviledge for sys.V_$PARAMETER view
> > and it says "ora990 - missing or invalid priviledge"
> >
> > Do you know what I need to do?
> >
> > Cheers,
> > Graeme
> >
> > P.S. I'm using Oracle 9i and the patched version of designer/repository
> > which is supposed to be OK.
> >
> >
>
>
Received on Thu Nov 29 2001 - 22:12:47 CET