This view from Victoria Yudin's web site will provide the information I think you need.
Kind regards,
Leslie
CREATE VIEW view_Security_Roles_and_Tasks
AS
/**
view_Security_Roles_and_Tasks
Created Mar 12 2009 by Victoria Yudin - Flexible Solutions, Inc.
For updates see victoriayudin.com/gp-reports
Shows all security roles and tasks by user by company
**/
SELECT S.USERID UserID, S.CMPANYID CompanyID,
C.CMPNYNAM CompanyName, S.SecurityRoleID,
coalesce(T.SECURITYTASKID,'') SecurityTaskID,
coalesce(TM.SECURITYTASKNAME,'') SecurityTaskName,
coalesce(TM.SECURITYTASKDESC,'') SecurityTaskDescription
FROM SY10500 S -- security assignment user role
LEFT OUTER JOIN
SY01500 C -- company master
ON S.CMPANYID = C.CMPANYID
LEFT OUTER JOIN
SY10600 T -- tasks in roles
ON S.SECURITYROLEID = T.SECURITYROLEID
LEFT OUTER JOIN
SY09000 TM -- tasks master
ON T.SECURITYTASKID = TM.SECURITYTASKID
/** the following will grant permissions to this view to DYNGRP,
leave this section off if you do not want to grant permissions **/
GO
GRANT SELECT ON view_Security_Roles_and_Tasks TO DYNGRP