[dbo].[HARITEMUSERACCESSVIEW]

(local) > harvest > Views > dbo.HARITEMUSERACCESSVIEW

Properties
Columns
SQL Script
Uses

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

Columns

Name
ITEMOBJID
USROBJID
VIEWACCESS

SQL Script

SET QUOTED_IDENTIFIER OFF
GO

   CREATE VIEW HARITEMUSERACCESSVIEW AS
   SELECT HARITEMACCESS.ITEMOBJID, HARUSERSINGROUP.USROBJID,
        MAX(HARITEMACCESS.VIEWACCESS) VIEWACCESS
   FROM HARITEMACCESS JOIN HARUSERSINGROUP ON HARITEMACCESS.USRGRPOBJID = HARUSERSINGROUP.USRGRPOBJID
   GROUP BY HARITEMACCESS.ITEMOBJID, HARUSERSINGROUP.USROBJID

GO

Uses

[dbo].[HARITEMACCESS]
[dbo].[HARUSERSINGROUP]
dbo