Lets say I have a user account that has not changed their password for 80 days and they are assigned to the default profile which has password life time set to unlimited.
If I change the value for the setting from unlimited to 60 will it lock out the user account?
You didn't specify an Oracle version, so this answer is coming from the 10g/11g world. It will not "lock" the account, it will "expire" the account, and give the user <FAILED_LOGIN_ATTEMPTS> attempts to login and change their password.
Sorry about that is 10g. Thanks this helps alot!