查看Oracle密码尝试限制次数
SQL> desc dba_profiles Name Null? Type ----------------------------------------- -------- ---------------------------- PROFILE NOT NULL VARCHAR2(128) RESOURCE_NAME NOT NULL VARCHAR2(32) RESOURCE_TYPE VARCHAR2(8) LIMIT VARCHAR2(128) COMMON VARCHAR2(3) INHERITED VARCHAR2(3) IMPLICIT VARCHAR2(3)
SQL> select *from dba_profiles where resource_name=‘FAILED_LOGIN_ATTEMPTS‘;
PROFILE
----------------------------------------------------------------------------------------------------
RESOURCE_NAME RESOURCE
-------------------------------- --------
LIMIT
----------------------------------------------------------------------------------------------------
COM INH IMP
--- --- ---
DEFAULT
FAILED_LOGIN_ATTEMPTS PASSWORD
10
NO NO NO
PROFILE
----------------------------------------------------------------------------------------------------
RESOURCE_NAME RESOURCE
-------------------------------- --------
LIMIT
----------------------------------------------------------------------------------------------------
COM INH IMP
--- --- ---
ORA_STIG_PROFILE
FAILED_LOGIN_ATTEMPTS PASSWORD
3
NO NO NO
可以看到默认的限制次数为10
将其修改为无限制或3次
SQL> alter profile default limit failed_login_attempts unlimited/3； profile altered.
原文：https://www.cnblogs.com/biebiejiujiu/p/13895251.html
【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！