Oracle changes the default password expiration days and number of locks

In the morning, I got a call from the lead in the elevator and said that the app couldn't get up. I ran up and checked the information and found that the application interface had always reported a wrong login database user and password. After checking that the database is restarted, the user name and password policies exceed the validity period.

Solution:

1. view which profile policy is used by the user

SQL> select username, profile from dba_users;

USERNAME PROFILE

-----------------------------------

MGMT_VIEW DEFAULT

SYS DEFAULT

SYSTEM DEFAULT

EKPUSER DEFAULT

2. view the valid days of the policy

SQL> Select * FROM dba_profiles s Where s. profile = 'default' AND resource_name = 'password _ LIFE_TIME '; PROFILE RESOURCE_NAME RESOURCE_TYPE LIMIT ------------------------------ --------------------- ---------- -------- DEFAULT PASSWORD_LIFE_TIME PASSWORD 180 3. change the policy to UNLIMITED and the number of locks to UNLIMITED. The DEFAULT value is 10.) SQL> Alter profile default limit PASSWORD_LIFE_TIME UNLIMITED; SQL> alter profile PROFILE_PERSONAL limit FAILED_LOGIN_ATTEMPTS UNLIMITED; Profile altered 4. check and confirm SQL> Select * FROM dba_profiles s Where s. profile = 'default' AND resource_name = 'password _ LIFE_TIME '; PROFILE RESOURCE_NAME RESOURCE_TYPE LIMIT quota -------------------- ------------- ---------- DEFAULT PASSWORD_LIFE_TIME password unlimited is modified to take effect immediately without restarting the database

This article from the "No dual city" blog, please be sure to keep this source http://929044991.blog.51cto.com/1758347/1162540