CREATE view usd_v_targets_os_s
(    uri, user_uuid,
    agent_name, agent_type, agent_uuid,
    proc_os_name,
        is_boot_server, is_staging_server, is_user, is_computer, server_label)

as
select     uri, user_uuid,
    agent_name, agent_type, agent_uuid,
    proc_os_name,
        is_boot_server, is_staging_server, is_user, is_computer, server_label

from     usd_v_user_dhw_sec, usd_v_targets_os

where    usd_v_user_dhw_sec.dhw_uuid
        = usd_v_targets_os.agent_uuid
GO
GRANT SELECT ON  [dbo].[usd_v_targets_os_s] TO [ams_group]
GRANT REFERENCES ON  [dbo].[usd_v_targets_os_s] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_v_targets_os_s] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[usd_v_targets_os_s] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[usd_v_targets_os_s] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[usd_v_targets_os_s] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_v_targets_os_s] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[usd_v_targets_os_s] TO [upmuser_group]
GO