create view usm_vw_request_access as
  SELECT r.request_id, l.user_id, NULL AS group_id
  FROM   usm_request r, usm_link_account_user l
  WHERE ((r.req_by_account_id = l.account_id AND r.req_by_account_id IS NOT NULL) OR
         (r.req_for_account_id = l.account_id AND r.req_for_account_id IS NOT NULL))
  UNION
  SELECT r.request_id, p.user_id, p.group_id
  FROM   usm_request r, usm_request_pending_action p
  WHERE  p.request_id = r.request_id
GO
GRANT SELECT ON  [dbo].[usm_vw_request_access] TO [usmgroup]
GO