Views [dbo].[harapprovehistview]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created12:32:09 PM Sunday, December 05, 2010
Last Modified12:32:09 PM Sunday, December 05, 2010
Columns
Name
envobjid
stateobjid
packageobjid
usrobjid
actiontime
Permissions
TypeActionOwning Principal
GrantSelectharvest_group
GrantSelectharvest_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
Used By