SELECT Distinct
SecurityObjInstances.InstanceKey AS ‘object’,
SecurityObjInstances.UserName,
vSecurityClassPermissions.PermissionName
FROM SecurityObjInstances SecurityObjInstances,
vSecurityClassPermissions vSecurityClassPermissions
WHERE vSecurityClassPermissions.ObjectKey = SecurityObjInstances.ObjectKey
AND vSecurityClassPermissions.UserName = SecurityObjInstances.UserName
ORDER BY
SecurityObjInstances.InstanceKey,
SecurityObjInstances.UserName,
vSecurityClassPermissions.PermissionName