Roles assigned to a User

-- 
SELECT
    pu.username
  , pur.role_id
  , pr.active_flag
  , pr.role_common_name
FROM
    fusion.per_users      pu
  , fusion.per_user_roles pur
  , fusion.per_roles_dn   pr
WHERE
    pu.user_id                = pur.user_id
    AND pur.role_id           = pr.role_id
    AND upper(Pu.Username) like upper(:xdo_user_name)
ORDER BY
    pu.username