[dbo].[HARREPOSITORYUSERACCESSVIEW]
SET QUOTED_IDENTIFIER OFF
GO
CREATE VIEW HARREPOSITORYUSERACCESSVIEW AS
SELECT HARREPOSITORYACCESS.REPOSITOBJID, HARUSERSINGROUP.USROBJID,
MAX(HARREPOSITORYACCESS.SECUREACCESS) SECUREACCESS,
MAX(HARREPOSITORYACCESS.UPDATEACCESS) UPDATEACCESS,
MAX(HARREPOSITORYACCESS.VIEWACCESS) VIEWACCESS
FROM HARREPOSITORYACCESS JOIN HARUSERSINGROUP
ON HARREPOSITORYACCESS.USRGRPOBJID = HARUSERSINGROUP.USRGRPOBJID
GROUP BY HARREPOSITORYACCESS.REPOSITOBJID, HARUSERSINGROUP.USROBJID
GO
