2 Replies Latest reply: Dec 7, 2008 6:37 AM by SatishKandi RSS

    FAILED_LOGIN_ATTEMPTS

    576856
      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....
          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
            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.