The requirements for elementary school honor roll vary significantly from school to school and even district to district. There's no single, universal standard. Some schools might require all A's, others might allow a few B's while still granting honor roll status.
To find out the specific requirements, you should check your child's school's or district's website or contact the school office directly.