We have ORACLE database on ORACLE 11.2.0.3 when I use "sqlplus" login and get warning: Enter user-name: user1 Enter password: ERROR: ORA-28002: the password will expire within 1 days I double check password_life_time set to 180 (default). I change it to unlimited. SQL> alter profile default limit PASSWORD_LIFE_TIME unlimited; I still get same warning: Enter user-name: user1 Enter password: ERROR: ORA-28002: the password will expire within 1 days Anyone know why? -- //www.freelists.org/webpage/oracle-l