Re: Access to v$views

There is a predefined role SELECT_CATALOG_ROLE (at least in Oracle 8) which does the thing....

Krister Lundmark

Doug Cowles <dcowles_at_bigfoot.com> wrote in message news:379170C3.F723AE6E_at_bigfoot.com...
> So are they all conveniently in a table so that I can do this sort of
thing?
>
> select 'grant select on v_$'||substr(viewname,3,........ to developer?
>
> - Dc.
>
> Brian Peasland wrote:
>
> > >How do I give a developer access to all
> > >of the v$views?
> >
> > The only way I know how to give them access to the v$ views is to grant
them
> > access for each view that you want them to be able to see. (or you can
grant
> > them DBA, but that's probably not what you want). When granting access
to v$
> > views, you have to follow a simple, but odd procedure. The user SYS owns
> > these views, so you first have to log on as SYS. Then, you grant select
on
> > the underlying v_$ view. For instance, to grant user1 select on
v$instance,
> > do:
> >
> > SQL> connect sys/change_on_install
> > SQL> grant select on v_$instance to user1;
> >
> > User1 should now be able to query v$instance. But he won't be able to
query
> > v_$instance. This is weird, but it's the way that it works.
> >
> > Hope that helps,
> > Brian Peasland
> > peasland_at_msn.com
>
>
>
Received on Sun Aug 01 1999 - 12:48:58 CDT