Views [dbo].[harapprovehistview]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created11:10:13 AM Wednesday, March 07, 2007
Last Modified11:10:13 AM Wednesday, March 07, 2007
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