Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-28002: Password will expire in x days

user106405Nov 19 2009 — edited Nov 20 2009

Hi guys,

This is my first post so bare with me if I ask stupid things. I have test 10.2.0.4 server that I use for fulling around and I played with default profile recently (password expiration). Once I finished I returned everything back, at least that's what I though but now I am getting "ORA-28002: Password will expire in 14 days" error when I try to connect. I returned all password settings to UNLIMITED. Is this default setting for DEFAULT profile or I did something wrong? I thought UNLIMITED is something like "NEVER EXPIRE".

Anyway, user account has DEFAULT profile attached to it and all password settings are set to UNLIMITED except "Complexity Function" which is set to NULL.

Thanks for all answers!!

This post has been answered by Robert Geier on Nov 20 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 18 2009

Added on Nov 19 2009

#general-database-discussions

18 comments

10,291 views