Views [dbo].[iam_global_membership_view]
(local) > mdb > Views > dbo.iam_global_membership_view
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created11:10:20 AM Wednesday, March 07, 2007
Last Modified11:10:20 AM Wednesday, March 07, 2007
Columns
Name
user_group_name
user_group_object_guid
user_name
user_object_guid
SQL Script

CREATE VIEW "iam_global_membership_view" ("user_group_name", "user_group_object_guid", "user_name", "user_object_guid")  AS
       SELECT iav.attribute_shortvalue, iav.object_guid, "iguv"."object_name", "iguv"."object_guid"
       FROM "iam_attribute_view" "iav", "iam_global_user_view" "iguv"
       WHERE iav.object_guid = iguv.object_guid AND iav.attribute_name = 'pzGroupMembership'


GO
Uses
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved