Re: password going to expire

From: Ryan January <rjjanuary_at_multiservice.com>
Date: Tue, 04 Sep 2012 11:34:45 -0500
Message-ID: <50462DA5.6050501_at_multiservice.com>

I was able to recreate the issue (ORA-28002) and feel your password has *already* expired and you've entered the grace period. In the below test note that I set the grace period for a non standard 10 days. At this point you should probably reset the user's password. Once that is completed you will find that the new password will not have an expiration.

SQL> drop user testuser1;

User dropped.

SQL> drop profile testprof1;

Profile dropped.

SQL> create profile testprof1 limit PASSWORD_LIFE_TIME 1;

Profile created.

SQL> create user testuser1 identified by password1 profile testprof1;

User created.

SQL> alter profile testprof1 limit password_grace_time 10;

Profile altered.

SQL> select resource_name, limit from dba_profiles where profile= 'TESTPROF1'; RESOURCE_NAME LIMIT

-------------------------------- ----------------------------------------
COMPOSITE_LIMIT          DEFAULT
SESSIONS_PER_USER         DEFAULT
CPU_PER_SESSION          DEFAULT
CPU_PER_CALL             DEFAULT
LOGICAL_READS_PER_SESSION     DEFAULT
LOGICAL_READS_PER_CALL         DEFAULT
IDLE_TIME             DEFAULT
CONNECT_TIME             DEFAULT
PRIVATE_SGA             DEFAULT
FAILED_LOGIN_ATTEMPTS         DEFAULT
PASSWORD_LIFE_TIME         1

RESOURCE_NAME             LIMIT
-------------------------------- ----------------------------------------
PASSWORD_REUSE_TIME         DEFAULT
PASSWORD_REUSE_MAX         DEFAULT
PASSWORD_VERIFY_FUNCTION     DEFAULT
PASSWORD_LOCK_TIME         DEFAULT
PASSWORD_GRACE_TIME         10

16 rows selected.

SQL> alter profile testprof1 limit password_life_time 1/86400; -- set password expiration for 1 second

Profile altered.

SQL> select username, account_status,expiry_date from dba_users where username = 'TESTUSER1';

USERNAME EXPIRY_DATE

------------------------------ ------------------

TESTUSER1               04-SEP-12

SQL> grant connect to testuser1;

Grant succeeded.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

$ rlwrap sqlplus testuser1/password1

SQL*Plus: Release 11.2.0.3.0 Production on Tue Sep 4 11:23:15 2012

ERROR:
ORA-28002: the password will expire within 10 days

$ rlwrap sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Sep 4 11:24:31 2012

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

SQL> alter profile testprof1 limit password_life_time unlimited;

Profile altered.

$ rlwrap sqlplus testuser1/password1

SQL*Plus: Release 11.2.0.3.0 Production on Tue Sep 4 11:25:01 2012

ERROR:
ORA-28002: the password will expire within 10 days

On 09/04/2012 11:12 AM, dba1 mcc wrote:
> 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
>
>

This email is intended solely for the use of the addressee and may contain information that is confidential, proprietary, or both. If you receive this email in error please immediately notify the sender and delete the email.

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

Received on Tue Sep 04 2012 - 11:34:45 CDT

This message: [ Message body ]
Next message: Patterson, Joel: "To patch or not to patch oracle 10.2.0.4.0"
Previous message: Sheehan, Jeremy: "RE: password going to expire"
In reply to: dba1 mcc: "Re: password going to expire"
Next in thread: Sriram Kumar: "Re: password going to expire"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message