Oracle Set User Password never expires

1, view the user's profile is that, is generally default:

Select Username, profile from dba_users;


2. View the password expiration settings for the specified profile (such as default):

SELECT * from dba_profiles where profile = ' DEFAULT ' and resource_name = ' password_life_time ';


3. Change the password validity period from the default 180 days to "unlimited":

ALTER profile DEFAULT LIMIT password_life_time UNLIMITED;


4, after the modification, has not been prompted ORA-28002 warning account will not encounter the same problem, the account has been prompted to change the password again:

ALTER USER Wumall identified by Wumall;

Oracle Set User Password never expires