There is the overall locking password, which prevents the phone from being used. Is there a way to pasword-protect on a per-app basis, e.g. lock mail, but not photos. This is under iOS 5.1 on a iPhone 4S. The password doesn't need to be different between apps, however.
EDIT: This is with a iPhone 4S, not jailbroken.