in Lion, System Preferences, Users & Groups, set a password for user account.
Click Login Options on the left, and then disable automatic login on the right.
Also in System Preferences, Security & Privacy, General tab, Require password Immediately after Sleep or screen saver begins.