My Oracle Support Banner

User SYS Does Not Get ORA-28002 Nor ORA-28001 Even When PASSWORD_LIFE_TIME or PASSWORD_GRACE_TIME are Set (Doc ID 289898.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.
Checked for relevance on 07-Jun-2013


The PASSWORD_LIFE_TIME and PASSWORD_GRACE_TIME parameters of a resource profile seem to be working for all the users but not for SYS:

SQL> create profile test_prof
limit password_life_time 5/1440 -- 5 minutes
password_grace_time 1/1440; -- 1 minute

SQL> set time on

14:07:34 SQL> alter user SYS profile test_prof;
14:07:39 SQL> alter user SYSTEM profile test_prof;

14:08:40 SQL> connect SYS/oracle as sysdba

14:08:41 SQL> connect SYSTEM/oracle
ORA-28002: the password will expire within 0 days

14:33:40 SQL> connect SYS/oracle as sysdba

14:34:33 SQL> connect SYSTEM/manager
ORA-28001: the password has expired


Is there anything to be done to solve this?



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.