3 Replies Latest reply: Jun 24, 2014 8:17 AM by Galib Hussain RSS

    display user owned only sessions info




      I'm looking for a solution to grant limited access to v$session , so specified database user can list only sessions owned by himself.


      something like a public version of:


      select * from v$session

      where username = user;


      I can make this by granting v_$session to specified user. But there is no much sense in it since v_$session shows all sessions.


      So is there better approach ?