11gR2 : access to v$session with only create session privilege ?
Hi ,
I would like tounderstand how is it possible to access to v$session with only create session privilege ?
Best regards.
GD.
SQL> create user utoto identified by toto ;
User created
SQL> grant create session to utoto ;
Grant succeeded
SQL> connect utoto/toto;
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.3.0
Connected as utoto
SQL> show user ;
User is "utoto"
SQL> select * from v$instance ;
select * from v$instance
ORA-00942: table or view does not exist
SQL> select * from dba_objects ;
select * from dba_objects
ORA-00942: table or view does not exist
SQL> select * from v$session ;
SADDR SID SERIAL# AUDSID PADDR USER# USERNAME COMMAND