Toad for Oracle - Session Manager - required GRANTS

Access to the following views required: V$SESSION, V$PROCESS, V$SESS_IO, V$SESSION_WAIT, V$SESSION_EVENT, V$ACCESS, V$SESSSTAT, V$STATNAME, V$OPEN_CURSOR, V$SQL, V$LOCK, V$SESSION_LONGOPS, V$TRANSACTION, V$ROLLNAME, V$SQLTEXT_WITH_NEWLINES, V$EVENTMETRIC, V$EVENT_NAME, V$SESSION_EVENT

Use

GRANT SELECT_CATALOG_ROLE TO {USER};

and to revert everything ...

REVOKE SELECT_CATALOG_ROLE FROM {USER};

Or

GRANT SELECT ON V_$SESSION TO {USER};
GRANT SELECT ON V_$PROCESS TO {USER};
GRANT SELECT ON V_$SESS_IO TO {USER};
GRANT SELECT ON V_$SESSION_WAIT TO {USER};
GRANT SELECT ON V_$SESSION_EVENT TO {USER};
GRANT SELECT ON V_$ACCESS TO {USER};
GRANT SELECT ON V_$SESSTAT TO {USER};
GRANT SELECT ON V_$STATNAME TO {USER};
GRANT SELECT ON V_$OPEN_CURSOR TO {USER};
GRANT SELECT ON V_$SQL TO {USER};
GRANT SELECT ON V_$LOCK TO {USER};
GRANT SELECT ON V_$SESSION_LONGOPS TO {USER};
GRANT SELECT ON V_$TRANSACTION TO {USER};
GRANT SELECT ON V_$ROLLNAME TO {USER};
GRANT SELECT ON V_$SQLTEXT_WITH_NEWLINES TO {USER};
GRANT SELECT ON V_$EVENTMETRIC TO {USER};
GRANT SELECT ON V_$EVENT_NAME TO {USER};
GRANT SELECT ON V_$SESSION_EVENT TO {USER};

and again to revert everything ...

REVOKE SELECT ON V_$SESSION FROM {USER};
REVOKE SELECT ON V_$PROCESS FROM {USER};
REVOKE SELECT ON V_$SESS_IO FROM {USER};
REVOKE SELECT ON V_$SESSION_WAIT FROM {USER};
REVOKE SELECT ON V_$SESSION_EVENT FROM {USER};
REVOKE SELECT ON V_$ACCESS FROM {USER};
REVOKE SELECT ON V_$SESSTAT FROM {USER};
REVOKE SELECT ON V_$STATNAME FROM {USER};
REVOKE SELECT ON V_$OPEN_CURSOR FROM {USER};
REVOKE SELECT ON V_$SQL FROM {USER};
REVOKE SELECT ON V_$LOCK FROM {USER};
REVOKE SELECT ON V_$SESSION_LONGOPS FROM {USER};
REVOKE SELECT ON V_$TRANSACTION FROM {USER};
REVOKE SELECT ON V_$ROLLNAME FROM {USER};
REVOKE SELECT ON V_$SQLTEXT_WITH_NEWLINES FROM {USER};
REVOKE SELECT ON V_$EVENTMETRIC FROM {USER};
REVOKE SELECT ON V_$EVENT_NAME FROM {USER};
REVOKE SELECT ON V_$SESSION_EVENT FROM {USER};

NOTE: Tested on Oracle Database 11g Enterprise Edition Release 11.1.0.6.0