Oracle View user password expires, modification never expires

1. View open Users

Select Username,account_status,expiry_date,profile from Dba_users;

2. View current password expiration policy

SELECT * from Dba_profiles s where s.profile= ' DEFAULT ' and resource_name= ' password_life_time ';

3. Modify Password Expiration policy

Alter profile default limit Password_life_time unlimited;

4. Expired account Change password will not expire again

$sqlplus/as SYSDBA

Alter user SMSC identified by < original password >----do not change the new password

The source of the plank: http://xiaochina.cnblogs.com/

Oracle View user password expires, modification never expires