[dbo].[harapprovehistview]

(local) > mdb > Views > dbo.harapprovehistview

Properties
Columns
Permissions
SQL Script
Uses
Used By

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	11:10:13 AM Wednesday, March 07, 2007
Last Modified	11:10:13 AM Wednesday, March 07, 2007

Columns

Name
envobjid
stateobjid
packageobjid
usrobjid
actiontime

Permissions

Type	Action	Owning Principal
Grant	Select	harvest_group
Grant	Select	harvest_rep

SQL Script

CREATE VIEW "harapprovehistview" ("envobjid", "stateobjid", "packageobjid", "usrobjid", "actiontime")  AS
       SELECT DISTINCT "harapprovehist"."envobjid", "harapprovehist"."stateobjid", "harapprovehist"."packageobjid", "harapprovehist"."usrobjid", MAX(execdtime)
       FROM "harapprovehist"
       GROUP BY envobjid, stateobjid, packageobjid, usrobjid

GO
GRANT SELECT ON  [dbo].[harapprovehistview] TO [harvest_group]
GRANT SELECT ON  [dbo].[harapprovehistview] TO [harvest_rep]
GO

Uses

[dbo].[harapprovehist]
dbo

Used By

[dbo].[harapprovehistactionview]