Re: V$SESSION who can access to this view

User SYS owns tables called X$ tables (which are actually C programs that Oracle sees as tables). On these tables V$ views are created, also owned by SYS. You can't grant any permissions, even select, on these V$ views.  The catalog.sql script creates V_$ views on the V$ views. The owner of the V_$ views is, once again, SYS. Finally Public synonyms with the prefix V$ are created on all the V_$ views.
 So when you look at a V$ view what you are really seeing is a public synonym created on a sys.V_$ view created on a sys.V$ view created on an sys.X$ table.

Van

Nicolas Bronke <newsgroup_at_trinity.de> wrote in message news:387f797a_4_at_news2.prserv.net...
> > > Which privileges are necessary to perform a select * from v$session.
> > >
> > > I would like to grant this rights someone without DBA-rights
> > >
> > > I tried to perform a grant select using the SYSTEM user. But system
> > does not
> > > have enough rights.
> > > I tried to perform a grant select using the SYS user. I got the error
> > > message that this is not possible!
> > >
> > > Does exist a possibility on Oracle 8.0.5?
> >
> > create or replace view v_$session as select * from v$session;
> > drop public synonym v$session;
> > create public synonym v$session for v_$session;
> > grant select on v_$session to select_catalog_role;
> >
> Thanks a lot. Your hint gave me the final hint. The solution is
>
> grant select on V_$session to myrole
>
> everything as user SYS
>
> Anything else is not necessary
>
> I do not know why, but it works.
>
> Regards
> Nicolas
>
>
>
>
Received on Sat Jan 15 2000 - 17:30:40 CST