ITPub博客

检查PASSWORD_LIFE_TIME应小于或等于90  select limit from dba_profiles t where resource_name = 'PASSWORD_LIFE_TIME';select distinct profile from dba_profiles;修改为60天alter profile profile_name limit PASSWORD_LIFE_TIME 60;

查看错误的密码连接用户select limit from dba_profiles t where resource_name = 'FAILED_LOGIN_ATTEMPTS'; 修改为6次alter profile default limit FAILED_LOGIN_ATTEMPTS 6; 解锁：alter user user_name account unlock;