RE: password going to expire
Date: Tue, 4 Sep 2012 11:58:58 -0400
Message-ID: <C3F905167E081B418BFC63B8668D52FF245F231D0D_at_GOXEXVS03.fplu.fpl.com>
What are the results when you run the following query?
Select username,profile,expiry_date
From dba_users
Where username = 'USER1'
Jeremy
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc
Sent: Tuesday, September 04, 2012 11:29 AM
To: oracle-l_at_freelists.org
Subject: password going to expire
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
Received on Tue Sep 04 2012 - 10:58:58 CDT