Its common requirement of Developers to access the Sp_who2, Sp_who3, Sp_whoisactive and SHOWPLAN of executed quires or procedures for check the DB server sessions, health, blocking and execution plan check. But DBA mostly denied granting this access mostly required the sysadmin access to execute this kind of queries.
We can grant access to these procedures or SHOWPLAN without granting any sysadmin access. For this you have to grant the VIEW SERVER STATE permission and individually procedure execution permissions.
Also, you can make a make a separately db_showplan role for it and can make the member of this group to users.
