Re: v_$session, v_$mystat ...?

>I created an instance (DTGN) and a database (datagen).
>Then I created a user (sergey). When I connect as
>system/manager I can query v_$session and v_$mystat
>in sys schema through public synonyms v$session and
>v$mystat. However, when I connect as sergey/password,
>the public synonyms are there, but v_$session and
>v_$mystat are not in sys schema. Is there some sql script
>that I need to run?

Login as sys and grant v_$session and v_$mystat to sergey like this

grant select on v_$session to sergey;
grant select on v_$mystat to sergey;

Rauno Received on Tue Aug 31 1999 - 06:03:20 CDT