Changing the Oracle user password will never expire

Changing the Oracle user password will never expire

Changing the Oracle user password will never expire

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 prompted account must be changed again

$ Sqlplus/as sysdba

SQL> alter user Username identified by password;