3 Replies Latest reply on Jun 24, 2014 1:17 PM by Galib Hussain

    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 ?