Does promotion imply tenure?

From GusWiki

In which US+Canadian universities does promotion to "Associate Professor" imply tenure?

Berkeley: yes

CMU: no

Harvard: no

Johns Hopkins: no

UBC: yes