SET QUOTED_IDENTIFIER OFF
GO

   CREATE VIEW HARHARVESTUSERACCESSVIEW AS
   SELECT HARUSERSINGROUP.USROBJID, MAX(HARHARVEST.SECUREHARVEST) SECUREHARVEST,
        MAX(HARHARVEST.ADMINUSER) ADMINUSER, MAX(HARHARVEST.VIEWUSER) VIEWUSER,
        MAX(HARHARVEST.ADMINENVIRONMENT) ADMINENVIRONMENT,
        MAX(HARHARVEST.VIEWENVIRONMENT) VIEWENVIRONMENT,
        MAX(HARHARVEST.ADMINREPOSITORY) ADMINREPOSITORY,
        MAX(HARHARVEST.VIEWREPOSITORY) VIEWREPOSITORY,
        MAX(HARHARVEST.ADMINFORMTYPE) ADMINFORMTYPE, MAX(HARHARVEST.VIEWFORMTYPE) VIEWFORMTYPE
   FROM HARHARVEST JOIN HARUSERSINGROUP ON HARHARVEST.USRGRPOBJID = HARUSERSINGROUP.USRGRPOBJID
   GROUP BY HARUSERSINGROUP.USROBJID  

GO