[dbo].[HARENVIRONMENTUSERACCESSVIEW]

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	5:00:30 AM Monday, March 02, 2009
Last Modified	5:00:30 AM Monday, March 02, 2009

Name
ENVOBJID
USROBJID
SECUREACCESS
UPDATEACCESS
VIEWACCESS
EXECUTEACCESS

SQL Script

SET QUOTED_IDENTIFIER OFF
GO

   CREATE VIEW HARENVIRONMENTUSERACCESSVIEW AS
   SELECT HARENVIRONMENTACCESS.ENVOBJID, HARUSERSINGROUP.USROBJID,
        MAX(HARENVIRONMENTACCESS.SECUREACCESS) SECUREACCESS,
        MAX(HARENVIRONMENTACCESS.UPDATEACCESS) UPDATEACCESS,
        MAX(HARENVIRONMENTACCESS.VIEWACCESS) VIEWACCESS,
        MAX(HARENVIRONMENTACCESS.EXECUTEACCESS) EXECUTEACCESS
   FROM HARENVIRONMENTACCESS JOIN HARUSERSINGROUP
       ON HARENVIRONMENTACCESS.USRGRPOBJID = HARUSERSINGROUP.USRGRPOBJID
   GROUP BY HARENVIRONMENTACCESS.ENVOBJID, HARUSERSINGROUP.USROBJID

GO