CREATE VIEW dbo.wvAIX 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 INNER JOIN
                      dbo.wtAIX b ON a.uuid = b.uuid
GO
GRANT SELECT ON  [dbo].[wvAIX] TO [uniadmin]
GRANT SELECT ON  [dbo].[wvAIX] TO [uniuser]
GRANT SELECT ON  [dbo].[wvAIX] TO [wvadmin]
GRANT SELECT ON  [dbo].[wvAIX] TO [wvuser]
GO