[dbo].[HARSTATEPROCESSUSERACCESSVIEW]

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
STATEOBJID
PROCESSOBJID
USROBJID
EXECUTEACCESS

SQL Script

SET QUOTED_IDENTIFIER OFF
GO

   CREATE VIEW HARSTATEPROCESSUSERACCESSVIEW AS
   SELECT HARSTATEPROCESSACCESS.STATEOBJID, HARSTATEPROCESSACCESS.PROCESSOBJID,
        HARUSERSINGROUP.USROBJID, MAX(HARSTATEPROCESSACCESS.EXECUTEACCESS) EXECUTEACCESS
   FROM HARSTATEPROCESSACCESS JOIN HARUSERSINGROUP
       ON HARSTATEPROCESSACCESS.USRGRPOBJID = HARUSERSINGROUP.USRGRPOBJID
   GROUP BY HARSTATEPROCESSACCESS.STATEOBJID, HARSTATEPROCESSACCESS.PROCESSOBJID,
        HARUSERSINGROUP.USROBJID

GO