Originally posted by aruneeshsalhotr
That does not work fine ..
I solved the problem and found the solution:
SYS has the ownership of V$SESSION - and this is not a real table or view. The user SYS has a view created V_$SESSION which has a public synonym called V$SESSION. Thats why it is readable from other schemas.
Rights to the view V_$SESSION can be granted to another user and afterwards the user can create a new view based on SYS.V_$SESSION.