Re: password going to expire

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Tue, 4 Sep 2012 09:12:58 -0700 (PDT)
Message-ID: <1346775178.5067.YahooMailNeo_at_web162702.mail.bf1.yahoo.com>

Enter user-name: system
Enter password:
ERROR:
ORA-28002: the password will expire within 1 days

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> set linesize 132
SQL> Select username,profile,expiry_date
  2  From dba_users
  3  Where username = 'USER1';

USERNAME                       PROFILE                        EXPIRY_DA
------------------------------ ------------------------------ ---------
USER1                                DEFAULT                        05-SEP-12

SQL> 

SQL>
SQL> alter profile default limit PASSWORD_LIFE_TIME unlimited;

Profile altered.

SQL>
SQL> Select username,profile,expiry_date
  2  From dba_users
  3  Where username = 'USER1';

USERNAME                       PROFILE                        EXPIRY_DA
------------------------------ ------------------------------ ---------
USER1                                DEFAULT                        05-SEP-12




________________________________

 From: "Sheehan, Jeremy" <JEREMY.SHEEHAN_at_nexteraenergy.com> To: dba1 mcc <mccdba1_at_yahoo.com>
Sent: Tuesday, September 4, 2012 12:07 PM Subject: RE: password going to expire  

What are the results when you run the following query?

Select username,profile,expiry_date
From dba_users
Where username = 'USER1'
 

Jeremy
 

From:dba1 mcc [mailto:mccdba1_at_yahoo.com] Sent: Tuesday, September 04, 2012 12:07 PM To: Sheehan, Jeremy
Subject: Re: password going to expire
 

default profile change to "unlimited" correctly.

I also tried :

alter profile default limit PASSWORD_LIFE_TIME  360;
 

still same warning.
 

---

From:"Sheehan, Jeremy" <JEREMY.SHEEHAN_at_nexteraenergy.com> To: "mccdba1_at_yahoo.com" <mccdba1_at_yahoo.com>; "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Sent: Tuesday, September 4, 2012 11:58 AM Subject: RE: password going to expire

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

Received on Tue Sep 04 2012 - 11:12:58 CDT