Database Administration (MOSC)

MOSC Banner

11gR2 : access to v$session with only create session privilege ?

edited May 6, 2014 12:00PM in Database Administration (MOSC) 10 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center