CREATE view usd_v_osim_targets_s
(
    uri, user_uuid,
    agent_name, agent_uuid, bootserver, mac_address
)


as
select     uri, user_uuid,
    agent_name, agent_uuid, bootserver, mac_address

from     usd_v_user_dhw_sec, usd_v_osim_targets

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