To modify the Oracle default password expiration days

Workaround:

1. View which profile strategy the user uses

Sql> select Username,profile from Dba_users;

USERNAME profile

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

Mgmt_view DEFAULT

SYS DEFAULT

SYSTEM DEFAULT

Ekpuser DEFAULT

2. View effective days for a policy

Sql> Select * from dba_profiles s Where s.profile= ' DEFAULT ' and resource_name= ' password_life_time ';

Profile Resource_name Resource_type LIMIT

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

DEFAULT Password_life_time PASSWORD 180

3. Modify policy is unrestricted

Sql> Alter profile DEFAULT LIMIT Password_life_time Unlimited;

Profile Altered

4. View Confirmation

Sql> Select * from dba_profiles s Where s.profile= ' DEFAULT ' and resource_name= ' password_life_time ';

Profile Resource_name Resource_type LIMIT

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

DEFAULT Password_life_time PASSWORD Unlimited

Modified to take effect in time without restarting the database