ORA-28002: the password will expire within 10 days Solution

ORA-28002: the password will expire within 10 days solution [SQL] solution: [SQL] 1. query this user's perfile file select username, profile from dba_users where username = 'Scott '; www.2cto.com 2. select * from dba_profiles where profile = 'default' Based on the file name query value '; 3. Change the password expiration time password_life_time to unlimited alter profile default limit password_life_time unlimited; www.2cto.com 4. Verify the query Password Complexity by verifying PASSWORD_VERIFY_FUNCTION VERIFY_FUNCTION alter profile default limit NULL) 5. Change the password to the original password alter user scott identified by tiger. The default value above may affect others. We recommend that you create a perfile file and bind it to the user.