Change Password Expire Policy for Database Users

To find the database profile values

select * from dba_profiles where resource_name like 'PASSWORD_LIFE_TIME';

It will provide the output like below, By default users password will expire in 180 days.

DEFAULT              PASSWORD_LIFE_TIME        PASSWORD 180

Change the password life time as unlimited, so that password will not expire for all users.

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

commit;


select * from dba_profiles where resource_name like 'PASSWORD_LIFE_TIME';