[dbo].[iam_global_membership

[dbo].[iam_global_membership_view]

(local) > mdb > Views > dbo.iam_global_membership_view

Properties
Columns
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	12:38:40 PM Sunday, December 05, 2010
Last Modified	12:38:40 PM Sunday, December 05, 2010

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

[dbo].[iam_attribute_view]
[dbo].[iam_global_user_view]
dbo