Administer Users by Role module - show users
I don't know whether this is correct or not but you can try this, 

function mymodule_views_query_alter(&amp;$view, &amp;$query) 
{
 global $user;
 $role=implode(', ', array_slice($user-&gt;roles, 1));//get the current user role
if ($view-&gt;name == 'your_view_name') 
{
  switch ($role) {
    case 'administrator':
//  drupal_set_message("administrator");
     // $query-&gt;add_where(); put your where condition
     // $view-&gt;query-&gt;set_group_operator('OR');
        break;
    case 'editor':
//  drupal_set_message("editor");
     // $query-&gt;add_where(); put your where condition
     // $view-&gt;query-&gt;set_group_operator('OR');
        break;
    case 'Member':
    //  drupal_set_message("Member");
      // $query-&gt;add_where(); put your where condition
     // $view-&gt;query-&gt;set_group_operator('OR');
        break;
        }
    } 

}