Re: Repository/Priveledges Problem
Date: Thu, 29 Nov 2001 18:46:40 -0000
Message-ID: <9u5vvh$u8n$1_at_news6.svr.pol.co.uk>
[Quoted] 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 - 19:46:40 CET