Shulou(Shulou.com)06/01 Report--

Customer environment: Oracle 11.2.0.4

11g default account expiration time is 180 days. You need to change the default policy to unlimited.

Select profile,resource_name,limit from dba_profiles where profile='DEFAULT'

Query default policy configuration

Alert profile default limit password_life_time unlimited

Change the password and never expire

Meaning of key parameters:

The life cycle of password_life_time passwords is 180 days by default.

The number of days you can continue to use the password_grace_time password after it expires

Login times are retried after incorrect failed_login_attempts password, and the account is automatically locked after reaching this number

After the password_lock_time password is locked, after this time, the system automatically unlocks the account the next time you log in to the system.

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.