Select C.IsGroup || '|' || A.ProgID || '|' || CAST(A.GrantedMask AS VARCHAR(10)) || '|' || CAST(A.DeniedMask AS VARCHAR(10)) from SecurityObjectRights A, SecurityRoles C where A.ClassID=:ClassID and A.Role_ID = C.ID and (A.Role_ID=:Role_ID or A.Role_ID IN (select Group_ID from SecurityRoleGroupLinks where Role_ID=:Role_ID)) Order by A.ProgID
Generated by ABRA Software a.s. 27.10.2021 16:34:11