Select tab_users.USER
 from tab_users , tab_grants , tab_roles r
  where tab_users.user_id = tab_grants.user_id(+)
        and tab_grants.role_id = tab_roles.role_id(+)
group by tab_users.USER
 having sum(decode(tab_roles.name,'Техподдержка',1,0)) = 0