CREATE VIEW "iam_global_user_attr_view" ("object_guid", "object_name", "attribute_name", "attribute_value", "attribute_shortvalue", "attribute_order")  AS
       SELECT "iguv"."object_guid", "iguv"."object_name", iav.attribute_name, iav.attribute_value, iav.attribute_shortvalue, iav.attribute_order
       FROM "iam_global_user_view" "iguv", "iam_attribute_view" "iav"
       WHERE iguv.object_guid = iav.object_guid


GO