How long can someone be blacklisted from opening an account?

This depends on what black list.

If a Particular bank puts you on their "Blacklist" you can and should assume you will be there for ever.

As to multi bank black lists, these are illeagle.

But the credit rating bureaus may have an incedent or bankruptcy listed for 7 years that would prevent opening an account.