The sys user and users granted the dba role or the select_catalog_role role can see the dynamic views. To be able to 'execute' a select (plsql?) you'll need to grant dml privs directly to a user (as sys: grant select on v$_session to <user>;).