[dbo].[HARENVWITHGROUPACCESSVIEW]
SET QUOTED_IDENTIFIER OFF
GO
CREATE VIEW HARENVWITHGROUPACCESSVIEW AS
SELECT HARENVIRONMENTACCESS.ENVOBJID, HARENVIRONMENTACCESS.USRGRPOBJID
FROM HARENVIRONMENTACCESS
UNION
SELECT HARSTATE.ENVOBJID, HARSTATEACCESS.USRGRPOBJID
FROM HARSTATE JOIN HARSTATEACCESS ON HARSTATE.STATEOBJID = HARSTATEACCESS.STATEOBJID
UNION
SELECT HARSTATE.ENVOBJID, HARSTATEPROCESSACCESS.USRGRPOBJID
FROM HARSTATE JOIN HARSTATEPROCESSACCESS ON HARSTATE.STATEOBJID = HARSTATEPROCESSACCESS.STATEOBJID
GO
