Oracle 设置密码尝试次数

查看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.