How to set password not to expire in oracle

Oracle's way to set a password that does not expire is:

1. Check which proifle the user has, usually default:

sql>SELECT username,PROFILE FROM dba_users;

2. Check Specify the password validity period setting for the 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;

There is no need to restart the database after the modification , will take effect immediately.

4. After modification, accounts that have not been prompted with ORA-28002 warning will not encounter the same prompt again;

Accounts that have been prompted must change their passwords again. For example: China Examination Network

$sqlplus / as sysdba
sql> alter user smsc identified by <原来的密码> ----不用换新密码

recommended tutorial: "Oracle Tutorial"

The above is the detailed content of How to set password not to expire in oracle. For more information, please follow other related articles on the PHP Chinese website!