How to change the validity period of ORACLE database password

This article introduces you how to modify the validity period of the ORACLE database password, the content is very detailed, interested friends can refer to, hope to be helpful to you.

Modification method

In the process of running the program, the program is often unable to access normally because the database password expires. In order to solve this problem, the following methods can be used:

1. Check which user's proifle is, usually default SELECT username,PROFILE FROM dba_users.

two。 View the password validity settings for the specified profile, such as default:

SELECT * FROM dba_profiles 's WHERE s.profileholders defaULT 'AND resource_name='PASSWORD_LIFE_TIME'

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

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; on how to change the validity period of the ORACLE database password to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.