add_filter( 'posts_where', 'creator_posts' );
function creator_posts( $where ){
global $wpdb, $pagenow, $current_user;
if ( is_admin() && $pagenow=='edit.php' && $current_user->user_login != 'admin') {
$where .= "AND (".$wpdb->posts.".post_author = '".$current_user->ID."' )";
}
return $where;
}
you can also add any other statements to IF block for example