Expired Oracle user logon password Modification

Expired Oracle user logon password Modification

1. Check the user's proifle, which is generally default:

SQL> SELECT username, PROFILE FROM dba_users;

2. view the password validity period settings of the specified profile (such as default:

SQL> SELECT * FROM dba_profiles s WHERE s. profile = \ 'default \ 'AND resource_name = \ 'password _ LIFE_TIME \';

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

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

After modification, the database does not need to be restarted and takes effect immediately.

4. After modification, the account has not been prompted ORA-28002 warning will not again encounter the same prompt;

The account that has been prompted must change the password again, for example:

$ Sqlplus/as sysdba

SQL> alter user smsc identified by <original password> ---- No new password required