[dbo].[harapproveactionview]

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

Name
ENVOBJID
STATEOBJID
PACKAGEOBJID
USROBJID
ACTIONTIME
ACTION
USRGRPOBJID
PROCESSOBJID

Type	Action	Owning Principal
Grant	Select	harvest_group
Grant	Select	harvest_rep

SQL Script

CREATE VIEW "harapproveactionview" ("ENVOBJID", "STATEOBJID", "PACKAGEOBJID", "USROBJID", "ACTIONTIME", "ACTION", "USRGRPOBJID", "PROCESSOBJID")  AS
       SELECT "v"."envobjid", "v"."stateobjid", "v"."packageobjid", "v"."usrobjid", "v"."actiontime", "v"."ACTION", "l"."usrgrpobjid", "l"."processobjid"
       FROM "harapprovehistactionview" "v", "harapprovelist" "l"
       WHERE v.stateobjid = l.stateobjid AND ((l.isgroup = 'N' AND l.usrobjid = v.usrobjid) OR (l.isgroup = 'Y' AND l.usrgrpobjid IN (SELECT usrgrpobjid FROM harusersingroup g WHERE v.usrobjid = g.usrobjid)))

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