How to change the validity period of the Oracle Default User Password

How to change the validity period of the Oracle Default User Password

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.

 

Http://four-corner.appspot.com/