No, but the other person's car insurance will cover you. Keep in mind that if you cause an accident while driving someone else's car, their premium may go up.
Note: If you have Damage to Someone Else's Vehicle coverage, we'll reimburse you up to $100,000 if you have an accident with a borrowed or rented vehicle in Canada or the US.