It depends. For overdraft services that are specific to automated teller machine (ATM) or one-time debit card transactions and for which the bank will charge a fee, one account holder is considered sufficient when opting-in. Similarly, for these types of overdraft services, the bank must treat revocation of consent by one account holder as revocation of consent for that account.
Contact your bank for other types of overdraft services offered.