[dbo].[HARSTATEUSERACCESSVIEW]

(local) > harvest > Views > dbo.HARSTATEUSERACCESSVIEW

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
STATEOBJID
USROBJID
UPDATEACCESS
UPDATEPKGACCESS

SQL Script

SET QUOTED_IDENTIFIER OFF
GO

   CREATE VIEW HARSTATEUSERACCESSVIEW AS
   SELECT HARSTATEACCESS.STATEOBJID, HARUSERSINGROUP.USROBJID,
        MAX(HARSTATEACCESS.UPDATEACCESS) UPDATEACCESS,
        MAX(HARSTATEACCESS.UPDATEPKGACCESS) UPDATEPKGACCESS
   FROM HARSTATEACCESS JOIN HARUSERSINGROUP ON HARSTATEACCESS.USRGRPOBJID = HARUSERSINGROUP.USRGRPOBJID
   GROUP BY HARSTATEACCESS.STATEOBJID, HARUSERSINGROUP.USROBJID

GO

Uses

[dbo].[HARSTATEACCESS]
[dbo].[HARUSERSINGROUP]
dbo