Re: V$SESSION who can access to this view

> > 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 Fri Jan 14 2000 - 13:09:13 CST