CREATE VIEW dbo.wvcaiAdEm AS SELECT a.name,a.label,a.address,a.address_type,a.class_name,a.status_no,a.weight,a.hidden,a.propagate_status,a.severity,a.posted,a.acknowledge,a.alarmset_name,a.autoarrange_type,a.date_ins,a.date_modify,a.code_page,a.admin_status,a.dsm_server,a.propagated_status_no,a.propagated_sev,a.dsm_address,a.license_machine_type,a.create_bpv,a.override_imagelarge,a.override_imagesmall,a.override_imagedecal,a.override_imagetintbool,a.override_model,a.background_image,a.interface_type,a.ip_address_hex,a.mac_address,a.subnet_mask,a.weighted_severity,a.max_sev,a.user_reclass,a.dnsname,a.source_repository,a.last_seen_time,a.amsserver,a.emserver,a.asset_uuid,a.common_discovery_name,a.ipv6_address,a.ipv6_address_hex,a.performance_report, b.* FROM dbo.tng_managedobject a, dbo.wtcaiAdEm b where a.uuid = b.uuid
GO
GRANT SELECT ON [dbo].[wvcaiAdEm] TO [uniadmin]
GRANT SELECT ON [dbo].[wvcaiAdEm] TO [uniuser]
GRANT SELECT ON [dbo].[wvcaiAdEm] TO [wvadmin]
GRANT SELECT ON [dbo].[wvcaiAdEm] TO [wvuser]
GO
[dbo].[wvcaiAdEm]