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