News, views, tips and tricks on Oracle and other fun stuff

Oracle DB 11g Password Expiry Gotcha

Jeff Hunter:

Something I discovered recently is that the DEFAULT profile for Oracle 11g sets the PASSWORD_LIFE_TIME to 180 instead of UNLIMTED by default.  Applications will encounter an “ORA-28002: the password will expire within X days” error message if you keep the default value.

To change the PASSWORD_LIFE_TIME, you:
ALTER PROFILE default LIMIT password_life_time UNLIMITED;

Read more about 11g new security related features here.

Filed in Links, Oracle, Tips on 11 Apr 11 | Tags: , , ,

Reader's Comments

  1. |

    Nice catch! Useful info. Thanks.