This discussion is archived
2 Replies Latest reply: Dec 7, 2008 4:37 AM by SatishKandi RSS

FAILED_LOGIN_ATTEMPTS

576856 Journeyer
Currently Being Moderated
Hi,

by default failed login attempts for default profile defined is 10, I want to change this to 10,000, how can I change

alter profile default limit failed_login_attempts 100000;

this is not working, please help me this regarding, I dont want to create new profile for this, i want to edit default profile????
  • 1. Re: FAILED_LOGIN_ATTEMPTS
    Aman.... Oracle ACE
    Currently Being Moderated
    What's the issue?Its working fine over my system on 11106.
    SQL> select profile,resource_name ,limit from dba_profiles where profile='DEFAULT';
    
    PROFILE                        RESOURCE_NAME
    ------------------------------ --------------------------------
    LIMIT
    ----------------------------------------
    DEFAULT                        COMPOSITE_LIMIT
    UNLIMITED
    
    DEFAULT                        SESSIONS_PER_USER
    UNLIMITED
    
    DEFAULT                        CPU_PER_SESSION
    UNLIMITED
    
    
    PROFILE                        RESOURCE_NAME
    ------------------------------ --------------------------------
    LIMIT
    ----------------------------------------
    DEFAULT                        CPU_PER_CALL
    UNLIMITED
    
    DEFAULT                        LOGICAL_READS_PER_SESSION
    UNLIMITED
    
    DEFAULT                        LOGICAL_READS_PER_CALL
    UNLIMITED
    
    
    PROFILE                        RESOURCE_NAME
    ------------------------------ --------------------------------
    LIMIT
    ----------------------------------------
    DEFAULT                        IDLE_TIME
    UNLIMITED
    
    DEFAULT                        CONNECT_TIME
    UNLIMITED
    
    DEFAULT                        PRIVATE_SGA
    UNLIMITED
    
    
    PROFILE                        RESOURCE_NAME
    ------------------------------ --------------------------------
    LIMIT
    ----------------------------------------
    DEFAULT                        FAILED_LOGIN_ATTEMPTS
    10
    
    DEFAULT                        PASSWORD_LIFE_TIME
    180
    
    DEFAULT                        PASSWORD_REUSE_TIME
    UNLIMITED
    
    
    PROFILE                        RESOURCE_NAME
    ------------------------------ --------------------------------
    LIMIT
    ----------------------------------------
    DEFAULT                        PASSWORD_REUSE_MAX
    UNLIMITED
    
    DEFAULT                        PASSWORD_VERIFY_FUNCTION
    NULL
    
    DEFAULT                        PASSWORD_LOCK_TIME
    1
    
    
    PROFILE                        RESOURCE_NAME
    ------------------------------ --------------------------------
    LIMIT
    ----------------------------------------
    DEFAULT                        PASSWORD_GRACE_TIME
    7
    
    
    16 rows selected.
    
    SQL> ALTER PROFILE DEFAULT
      2  LIMIT
      3  FAILED_LOGIN_ATTEMPTS 100;
    
    Profile altered.
    
    SQL> select profile,resource_name ,limit from dba_profiles where profile='DEFAULT';
    
    PROFILE                        RESOURCE_NAME
    ------------------------------ --------------------------------
    LIMIT
    ----------------------------------------
    DEFAULT                        COMPOSITE_LIMIT
    UNLIMITED
    
    DEFAULT                        SESSIONS_PER_USER
    UNLIMITED
    
    DEFAULT                        CPU_PER_SESSION
    UNLIMITED
    
    
    PROFILE                        RESOURCE_NAME
    ------------------------------ --------------------------------
    LIMIT
    ----------------------------------------
    DEFAULT                        CPU_PER_CALL
    UNLIMITED
    
    DEFAULT                        LOGICAL_READS_PER_SESSION
    UNLIMITED
    
    DEFAULT                        LOGICAL_READS_PER_CALL
    UNLIMITED
    
    
    PROFILE                        RESOURCE_NAME
    ------------------------------ --------------------------------
    LIMIT
    ----------------------------------------
    DEFAULT                        IDLE_TIME
    UNLIMITED
    
    DEFAULT                        CONNECT_TIME
    UNLIMITED
    
    DEFAULT                        PRIVATE_SGA
    UNLIMITED
    
    
    PROFILE                        RESOURCE_NAME
    ------------------------------ --------------------------------
    LIMIT
    ----------------------------------------
    DEFAULT                        FAILED_LOGIN_ATTEMPTS
    100
    
    DEFAULT                        PASSWORD_LIFE_TIME
    180
    
    DEFAULT                        PASSWORD_REUSE_TIME
    UNLIMITED
    
    
    PROFILE                        RESOURCE_NAME
    ------------------------------ --------------------------------
    LIMIT
    ----------------------------------------
    DEFAULT                        PASSWORD_REUSE_MAX
    UNLIMITED
    
    DEFAULT                        PASSWORD_VERIFY_FUNCTION
    NULL
    
    DEFAULT                        PASSWORD_LOCK_TIME
    1
    
    
    PROFILE                        RESOURCE_NAME
    ------------------------------ --------------------------------
    LIMIT
    ----------------------------------------
    DEFAULT                        PASSWORD_GRACE_TIME
    7
    
    
    16 rows selected.
    
    SQL>
    SQL> ALTER PROFILE DEFAULT
      2  LIMIT
      3  FAILED_LOGIN_ATTEMPTS 10000;
    
    Profile altered.
    
    SQL> select profile,resource_name ,limit from dba_profiles where profile='DEFAULT';
    
    PROFILE                        RESOURCE_NAME
    ------------------------------ --------------------------------
    LIMIT
    ----------------------------------------
    DEFAULT                        COMPOSITE_LIMIT
    UNLIMITED
    
    DEFAULT                        SESSIONS_PER_USER
    UNLIMITED
    
    DEFAULT                        CPU_PER_SESSION
    UNLIMITED
    
    
    PROFILE                        RESOURCE_NAME
    ------------------------------ --------------------------------
    LIMIT
    ----------------------------------------
    DEFAULT                        CPU_PER_CALL
    UNLIMITED
    
    DEFAULT                        LOGICAL_READS_PER_SESSION
    UNLIMITED
    
    DEFAULT                        LOGICAL_READS_PER_CALL
    UNLIMITED
    
    
    PROFILE                        RESOURCE_NAME
    ------------------------------ --------------------------------
    LIMIT
    ----------------------------------------
    DEFAULT                        IDLE_TIME
    UNLIMITED
    
    DEFAULT                        CONNECT_TIME
    UNLIMITED
    
    DEFAULT                        PRIVATE_SGA
    UNLIMITED
    
    
    PROFILE                        RESOURCE_NAME
    ------------------------------ --------------------------------
    LIMIT
    ----------------------------------------
    DEFAULT                        FAILED_LOGIN_ATTEMPTS
    10000
    
    DEFAULT                        PASSWORD_LIFE_TIME
    180
    
    DEFAULT                        PASSWORD_REUSE_TIME
    UNLIMITED
    
    
    PROFILE                        RESOURCE_NAME
    ------------------------------ --------------------------------
    LIMIT
    ----------------------------------------
    DEFAULT                        PASSWORD_REUSE_MAX
    UNLIMITED
    
    DEFAULT                        PASSWORD_VERIFY_FUNCTION
    NULL
    
    DEFAULT                        PASSWORD_LOCK_TIME
    1
    
    
    PROFILE                        RESOURCE_NAME
    ------------------------------ --------------------------------
    LIMIT
    ----------------------------------------
    DEFAULT                        PASSWORD_GRACE_TIME
    7
    
    
    16 rows selected.
    
    SQL>
    HTH
    Aman....
  • 2. Re: FAILED_LOGIN_ATTEMPTS
    SatishKandi Guru
    Currently Being Moderated
    Not adding anything to the answer here but it is working on my system at 10.2.0.4.0 as well.
    SQL> select * from dba_profiles where profile='DEFAULT';
    
    PROFILE                        RESOURCE_NAME                    RESOURCE LIMIT
    ------------------------------ -------------------------------- -------- ----------------------------------------
    DEFAULT                        COMPOSITE_LIMIT                  KERNEL   UNLIMITED
    DEFAULT                        SESSIONS_PER_USER                KERNEL   UNLIMITED
    DEFAULT                        CPU_PER_SESSION                  KERNEL   UNLIMITED
    DEFAULT                        CPU_PER_CALL                     KERNEL   UNLIMITED
    DEFAULT                        LOGICAL_READS_PER_SESSION        KERNEL   UNLIMITED
    DEFAULT                        LOGICAL_READS_PER_CALL           KERNEL   UNLIMITED
    DEFAULT                        IDLE_TIME                        KERNEL   UNLIMITED
    DEFAULT                        CONNECT_TIME                     KERNEL   UNLIMITED
    DEFAULT                        PRIVATE_SGA                      KERNEL   UNLIMITED
    DEFAULT                        FAILED_LOGIN_ATTEMPTS            PASSWORD 10
    DEFAULT                        PASSWORD_LIFE_TIME               PASSWORD UNLIMITED
    DEFAULT                        PASSWORD_REUSE_TIME              PASSWORD UNLIMITED
    DEFAULT                        PASSWORD_REUSE_MAX               PASSWORD UNLIMITED
    DEFAULT                        PASSWORD_VERIFY_FUNCTION         PASSWORD NULL
    DEFAULT                        PASSWORD_LOCK_TIME               PASSWORD UNLIMITED
    DEFAULT                        PASSWORD_GRACE_TIME              PASSWORD UNLIMITED
    
    16 rows selected.
    
    SQL> alter profile default limit failed_login_attempts 100000;
    
    Profile altered.
    
    SQL> select * from dba_profiles where profile='DEFAULT';
    
    PROFILE                        RESOURCE_NAME                    RESOURCE LIMIT
    ------------------------------ -------------------------------- -------- ----------------------------------------
    DEFAULT                        COMPOSITE_LIMIT                  KERNEL   UNLIMITED
    DEFAULT                        SESSIONS_PER_USER                KERNEL   UNLIMITED
    DEFAULT                        CPU_PER_SESSION                  KERNEL   UNLIMITED
    DEFAULT                        CPU_PER_CALL                     KERNEL   UNLIMITED
    DEFAULT                        LOGICAL_READS_PER_SESSION        KERNEL   UNLIMITED
    DEFAULT                        LOGICAL_READS_PER_CALL           KERNEL   UNLIMITED
    DEFAULT                        IDLE_TIME                        KERNEL   UNLIMITED
    DEFAULT                        CONNECT_TIME                     KERNEL   UNLIMITED
    DEFAULT                        PRIVATE_SGA                      KERNEL   UNLIMITED
    DEFAULT                        FAILED_LOGIN_ATTEMPTS            PASSWORD 100000
    DEFAULT                        PASSWORD_LIFE_TIME               PASSWORD UNLIMITED
    DEFAULT                        PASSWORD_REUSE_TIME              PASSWORD UNLIMITED
    DEFAULT                        PASSWORD_REUSE_MAX               PASSWORD UNLIMITED
    DEFAULT                        PASSWORD_VERIFY_FUNCTION         PASSWORD NULL
    DEFAULT                        PASSWORD_LOCK_TIME               PASSWORD UNLIMITED
    DEFAULT                        PASSWORD_GRACE_TIME              PASSWORD UNLIMITED
    
    16 rows selected.
    this is not working
    So please let us know how did you verify this.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points