v_$session, v_$mystat ...?

From: <sergey_s_at_my-deja.com>
Date: Mon, 30 Aug 1999 20:40:22 GMT
Message-ID: <7qeq7k$9r9$1@nnrp1.deja.com>

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?

It's v7.3.4 on NT.

Thank you.

Sergey

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Aug 30 1999 - 15:40:22 CDT