Query to get list of all active workflow users and their roles
select wu.name user_name, wr.name role_name from wf_users wu, wf_user_roles wur, wf_roles wr where wu.name = wur.user_name and wur.role_name = wr.name and wu.status = 'ACTIVE' and wr.status = 'ACTIVE' and wr.orig_system = 'WF_LOCAL_ROLES' order by wu.name, wr.name