Re: password going to expire

Hi,
If the user is already expired and is in the grace period then you will
face this. pls reset the password to same value using

alter user <username> identified by values <query from user$ for
name=username>

should solve the problem

best regards

sriram kumar


On Tue, Sep 4, 2012 at 8:58 PM, dba1 mcc <mccdba1@xxxxxxxxx> wrote:

> 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?
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>


--
http://www.freelists.org/webpage/oracle-l


Other related posts: