How to set the validity period of user password in oracle

This article introduces how to set the validity period of user password in oracle. The content is very detailed. Interested friends can use it for reference. I hope it will be helpful to you.

1. First, query the profile name to which the user belongs:

SELECT username, profile FROM dba_users

two。 Confirm the password validity of the profile queried above, such as default_profile.

SELECT * FROM dba_profiles WHERE profile LIKE 'DEFAULT%' AND RESOURCE_NAME='PASSWORD_LIFE_TIME'

3. Check whether PASSWORD_LIFE_TIME has been set and changed to the value you want to use. If the business does not want the password to expire, then UNLIMITED.

SQL > ALTER PROFILE default LIMIT PASSWORD_LIFE_TIME UNLIMITED

Query audit failed user information

Select ntimestamp# userid, userhost, terminal,a.* from aud$ a where returncode=1017 order by ntimestamp# desc

Effective immediately, invalid after restarting the database (if there are users who have been unable to log in due to repeated password errors before adding this parameter, they still cannot log in normally after adding the parameter):

Alter system set events='28401 TRACE NAME CONTEXT FOREVER, LEVEL 1'

Take effect after restart (restart the database or restart node instances sequentially):

ALTER SYSTEM SET EVENT='28401 TRACE NAME CONTEXT FOREVER, LEVEL 1 'SCOPE = SPFILE

Alter system set local_listener=' (ADDRESS= (PROTOCOL=TCP) (HOST=0.0.0.0) (PORT=1521)) 'sid='LJ'

So much for sharing about how to set the validity period of a user's password in oracle. I hope the above content can be of some help to you and learn more. If you think the article is good, you can share it for more people to see.