CREATE view usd_v_user_dhw_area_sec
(uri, user_uuid, domain_uuid, dhw_uuid
)

as
select uri, user_uuid, domain_uuid, dhw_uuid
from  usd_v_user_dhw_sec
where
         ( dhw_uuid IN  
             ( select object_def_uuid
                from ols_area_ace
                    where ( area_ace & area_mask
                                & [dbo].ols_fn_getAreaAceByUserUuid( usd_v_user_dhw_sec.user_uuid   )) != 0
             )  
         )
GO
GRANT SELECT ON  [dbo].[usd_v_user_dhw_area_sec] TO [ams_group]
GRANT SELECT ON  [dbo].[usd_v_user_dhw_area_sec] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_v_user_dhw_area_sec] TO [ca_itrm_group_ams]
GO