Database Password expiration settings

Detailed decomposition:

1.oracle11g Password Expiration

The database password is changed to infinity, to see what the user's proifle is, usually default:

1. sql>SELECT username,PROFILE FROM dba_users;

2. View the password expiration settings for the specified profile (such as default):

1. 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 of 180 days to "unlimited":

1. sql>ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

You do not need to restart the database after you modify it, it takes effect immediately.

Special note: Accounts that have been reported to expire passwords must be changed again (DBA authority required)

Database Password expiration settings