CREATE view ols_v_user as
    select    u.user_uuid as user_uuid,
            is_area_enabled =     case  s.set_val_lng when   0
                                then 0
                                /* if user is not inside a profile
                                   we asume hard restrictions: area_enabled */
                                else  min(isnull(usp.area_enabled,1) )
                                end,
            u.uri as uri
    from     ca_settings s,
            ca_discovered_user u left join
                ols_v_user_link_profile usp on u.user_uuid = usp.user_uuid,
            ca_settings s2
    where
            s.set_id = 901
            and ( u.domain_uuid = s2.set_val_uuid and    s2.set_id = 1
                )
group by u.user_uuid, u.uri, u.domain_uuid, s.set_val_lng
GO
GRANT SELECT ON  [dbo].[ols_v_user] TO [ams_group]
GRANT SELECT ON  [dbo].[ols_v_user] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[ols_v_user] TO [ca_itrm_group_ams]
GO