I'm not sure how being less abstract will help as the solution should be able to apply to any security context.

But to answer your question, in this specific case, I want to give read access to the system tables:

Master.sys.dm_exec_requests

Master.sys.dm_exec_sql_text