How tight should mountain bike brakes be?

[Daniel]

Should the wheel STOP or just slow when I put the brakes on?