ora-28002 – account_status column value changed by

— ora-28002 – account_status column value changed by
— default profile inquiry
select profile from dba_users where username = ‘<DB_USER_ID>’;

— default PROFILE passoword policy changed by UNLIMITED
alter profile default limit PASSWORD_LIFE_TIME UNLIMITED;

— account_status column value “EXPIRED(GRACE)” changed by PROFILE’s UNLIMITED value
— http://karellen.blogspot.kr/2013/01/ora-28002-password-will-expire-within-7.html
alter user <DB_USER_ID> identified by password;

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.