Create view usd_v_sserver_clients_s_v2
( uri, user_uuid, server_name, agent_name, object_uuid )    
as
select     uri, user_uuid, server_name, agent_name, object_uuid

from     usd_v_user_dhw_sec_v2, usd_v_sserver_clients

where    usd_v_user_dhw_sec_v2.dhw_uuid
        = usd_v_sserver_clients.object_uuid
GO
GRANT SELECT ON  [dbo].[usd_v_sserver_clients_s_v2] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[usd_v_sserver_clients_s_v2] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[usd_v_sserver_clients_s_v2] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[usd_v_sserver_clients_s_v2] TO [ca_itrm_group]
GO