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