Quote:
Originally posted by stecal
SQL> create user mike identified by mike;
User created.
SQL> grant connect,resource to mike;
Grant succeeded.
SQL> conn mike/mike
Connected.
SQL> select * from v$session;
select * from v$session
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> select * from v$mystat;
select * from v$mystat
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> conn system/manager
Connected.
SQL> grant select on v$mystat to mike;
grant select on v$mystat to mike
*
ERROR at line 1:
ORA-01031: insufficient privileges
SQL> conn sys/oracle
Connected.
SQL> grant select on v$mystat to mike;
grant select on v$mystat to mike
*
ERROR at line 1:
ORA-02030: can only select from fixed tables/views