Home › Increase Oracle failed login attempts

Increase Oracle failed login attempts 

Dr. Xi
Joined:
04/09/2007
Posts:
753

March 31, 2010 19:32:42    Last update: March 31, 2010 19:41:14
The dev database keeps locking up because of failed login attempts. For a dev database, we really don't need such security measure. This is how to remove the limit.

  1. Log in as sysdba 
    sqlplus sys@xe as sysdba

  2. Find out the profile for the user. 
    SQL> select profile from dba_users where username = 'HIBERNATE';

PROFILE
------------------------------
DEFAULT

  3. Look at the current limits 
    SQL> select resource_name, limit from dba_profiles where profile = 'DEFAULT';

RESOURCE_NAME                    LIMIT
-------------------------------- ----------------------------------------
COMPOSITE_LIMIT                  UNLIMITED
SESSIONS_PER_USER                UNLIMITED
CPU_PER_SESSION                  UNLIMITED
CPU_PER_CALL                     UNLIMITED
LOGICAL_READS_PER_SESSION        UNLIMITED
LOGICAL_READS_PER_CALL           UNLIMITED
IDLE_TIME                        UNLIMITED
CONNECT_TIME                     UNLIMITED
PRIVATE_SGA                      UNLIMITED
FAILED_LOGIN_ATTEMPTS            10
PASSWORD_LIFE_TIME               UNLIMITED

RESOURCE_NAME                    LIMIT
-------------------------------- ----------------------------------------
PASSWORD_REUSE_TIME              UNLIMITED
PASSWORD_REUSE_MAX               UNLIMITED
PASSWORD_VERIFY_FUNCTION         NULL
PASSWORD_LOCK_TIME               UNLIMITED
PASSWORD_GRACE_TIME              UNLIMITED

16 rows selected.

  4. Increase the value for failed login attempts 
    SQL> alter profile default limit failed_login_attempts unlimited;

Profile altered.

Share |
| Comment  | Tags
 

Related Notes