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

as
select ca_discovered_user.uri,
    ca_discovered_user.user_uuid,
    ca_discovered_user.domain_uuid,
    ca_object_ace.object_def_uuid

from    ca_object_ace,    
                ca_link_dis_user_sec_profile, ca_discovered_user

where (ca_object_ace.ace & 64) = 64
    AND ca_link_dis_user_sec_profile.security_profile_uuid = ca_object_ace.security_profile_uuid
                    AND  ca_discovered_user.user_uuid = ca_link_dis_user_sec_profile.user_uuid
union
    select ca_discovered_user.uri,
            ca_discovered_user.user_uuid,
            ca_discovered_user.domain_uuid,
            ca_link_object_owner.object_uuid
        from      ca_link_object_owner, ca_discovered_user
        where
            ca_discovered_user.user_uuid= ca_link_object_owner.owner_uuid
GO
GRANT SELECT ON  [dbo].[usd_v_user_dhw_sec] TO [ams_group]
GRANT SELECT ON  [dbo].[usd_v_user_dhw_sec] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_v_user_dhw_sec] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[usd_v_user_dhw_sec] TO [upmuser_group]
GO