CREATE VIEW "wvcities" ("uuid", "name", "label", "address", "address_type", "status_no", "hidden", "propagate_status", "severity", "posted", "acknowledge", "alarmset_name", "autoarrange_type", "date_ins", "date_modify", "code_page", "admin_status", "DSM_Server", "propagated_status_no", "propagated_sev", "DSM_Address", "license_machine_type", "create_bpv", "override_imagelarge", "override_imagesmall", "override_imagedecal", "override_imagetintbool", "override_model", "background_image", "class_name", "latitude", "longitude", "background", "geomap")  AS
       SELECT "m"."uuid", "m"."name", "m"."label", "m"."address", "m"."address_type", "m"."status_no", "m"."hidden", "m"."propagate_status", "m"."severity", "m"."posted", "m"."acknowledge", "m"."alarmset_name", "m"."autoarrange_type", "m"."date_ins", "m"."date_modify", "m"."code_page", "m"."admin_status", "m"."dsm_server", "m"."propagated_status_no", "m"."propagated_sev", "m"."dsm_address", "m"."license_machine_type", "m"."create_bpv", "m"."override_imagelarge", "m"."override_imagesmall", "m"."override_imagedecal", "m"."override_imagetintbool", "m"."override_model", "m"."background_image", "m"."class_name", "r"."latitude", "r"."longitude", "r"."background", "r"."geomap"
       FROM "tng_managedobject" "m", "tng_city" "r"
       WHERE m.uuid = r.uuid
GO
GRANT SELECT ON  [dbo].[wvcities] TO [uniadmin]
GRANT SELECT ON  [dbo].[wvcities] TO [uniuser]
GRANT SELECT ON  [dbo].[wvcities] TO [wvadmin]
GRANT SELECT ON  [dbo].[wvcities] TO [wvuser]
GO