SET QUOTED_IDENTIFIER OFF
GO

   CREATE VIEW HARENVWITHUSERACCESSVIEW AS
   SELECT HARENVIRONMENTACCESS.ENVOBJID, HARUSERSINGROUP.USROBJID
   FROM HARENVIRONMENTACCESS JOIN HARUSERSINGROUP
       ON HARENVIRONMENTACCESS.USRGRPOBJID = HARUSERSINGROUP.USRGRPOBJID
   UNION
   SELECT HARSTATE.ENVOBJID, HARUSERSINGROUP.USROBJID
   FROM HARSTATE JOIN HARSTATEACCESS ON HARSTATE.STATEOBJID = HARSTATEACCESS.STATEOBJID JOIN HARUSERSINGROUP
       ON HARSTATEACCESS.USRGRPOBJID = HARUSERSINGROUP.USRGRPOBJID
   UNION
   SELECT HARSTATE.ENVOBJID, HARUSERSINGROUP.USROBJID
   FROM HARSTATE JOIN HARSTATEPROCESSACCESS ON HARSTATE.STATEOBJID = HARSTATEPROCESSACCESS.STATEOBJID JOIN HARUSERSINGROUP
       ON HARSTATEPROCESSACCESS.USRGRPOBJID = HARUSERSINGROUP.USRGRPOBJID  

GO