Shulou(Shulou.com)05/31 Report--

This article introduces the knowledge of "how to change a user's password for an unlimited period of time". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

The password for oracle users is valid for 180 days by default. If you want to modify the user's validity period for an unlimited period, you can modify it by following the steps below:

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

After the modification, there is no need to restart the database, it will take effect immediately.

There is a problem. After the modification is completed, it will be approved.

Select username,EXPIRY_DATE from dba_users; queries that there are still users who show the expiration time of their passwords. You can use the

Alter user user name identified by user's original password; reset the user's password. After the password is set, it will be displayed that the user's password has an unlimited duration.

This is the end of the content of "how to change a user's password for an unlimited period of time by oracle". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.