This SQL should be able to provide a listing that only shows user groups currently granted permission to execute each process
SELECT HARENVIRONMENT.ENVIRONMENTNAME,
HARSTATE.STATENAME,
HARSTATEPROCESS.PROCESSNAME,
HARSTATEPROCESS.PROCESSTYPE,
HARUSERGROUP.USERGROUPNAME,
HARSTATEPROCESSACCESS.EXECUTEACCESS
FROM HARENVIRONMENT
INNER JOIN HARSTATE ON HARENVIRONMENT.ENVOBJID = HARSTATE.ENVOBJID
INNER JOIN HARSTATEPROCESS ON HARSTATE.STATEOBJID = HARSTATEPROCESS.STATEOBJID
INNER JOIN HARSTATEPROCESSACCESS ON HARSTATEPROCESS.PROCESSOBJID = HARSTATEPROCESSACCESS.PROCESSOBJID
INNER JOIN HARUSERGROUP ON HARUSERGROUP.USRGRPOBJID = HARSTATEPROCESSACCESS.USRGRPOBJID
WHERE HARSTATEPROCESSACCESS.EXECUTEACCESS = 'Y'
AND HARENVIRONMENT.ENVIRONMENTNAME = 'SampleProject' /* <--- Project name goes here */
/* AND HARSTATE.STATENAME = 'Development' /* <--- State name goes here */
/* AND HARSTATEPROCESS.PROCESSNAME = 'Check Out for Browse' /* <--- Process name goes here */
ORDER BY HARENVIRONMENT.ENVIRONMENTNAME,
HARSTATE.STATENAME,
HARSTATEPROCESS.PROCESSNAME,
HARUSERGROUP.USERGROUPNAME