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

    display user owned only sessions info

    jareeq

      Hi,

       

      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 ?

       

      Thanks