FAILED_LOGIN_ATTEMPTS

SQL> conn / as sysdba;
Connected.
SQL> alter user JTITSM account unlock;
User altered.
SQL> conn JTITSM/JTITSM
ERROR:
ORA-28000: the account is locked

Warning: You are no longer connected to ORACLE.
SQL> conn / as sysdba;
Connected.
SQL> alter user JTITSM account unlock;

User altered.

SQL> conn JTITSM/JTITSM
ERROR:
ORA-28000: the account is locked

Warning: You are no longer connected to ORACLE.
SQL>
SQL> conn / as sysdba;
Connected.
SQL> select username,account_status from dba_users where username='JTITSM';

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
JTITSM LOCKED(TIMED)

SQL> select profile
2 from dba_users
where username = 'JTITSM'; 3

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

SQL> SELECT resource_name,resource_type,limit FROM dba_profiles WHERE profile='DEFAULT';

RESOURCE_NAME RESOURCE
-------------------------------- --------
LIMIT
----------------------------------------
COMPOSITE_LIMIT KERNEL
UNLIMITED

SESSIONS_PER_USER KERNEL
UNLIMITED

CPU_PER_SESSION KERNEL
UNLIMITED

RESOURCE_NAME RESOURCE
-------------------------------- --------
LIMIT
----------------------------------------
CPU_PER_CALL KERNEL
UNLIMITED

LOGICAL_READS_PER_SESSION KERNEL
UNLIMITED

LOGICAL_READS_PER_CALL KERNEL
UNLIMITED

RESOURCE_NAME RESOURCE
-------------------------------- --------
LIMIT
----------------------------------------
IDLE_TIME KERNEL
UNLIMITED

CONNECT_TIME KERNEL
UNLIMITED

PRIVATE_SGA KERNEL
UNLIMITED

RESOURCE_NAME RESOURCE
-------------------------------- --------
LIMIT
----------------------------------------
FAILED_LOGIN_ATTEMPTS PASSWORD
10
SQL> SQL> alter profile default limit FAILED_LOGIN_ATTEMPTS 100000；
2
SQL> alter profile default limit FAILED_LOGIN_ATTEMPTS 100000;

Profile altered.

SQL> SELECT resource_name,resource_type,limit FROM dba_profiles WHERE profile='DEFAULT';

RESOURCE_NAME RESOURCE
-------------------------------- --------
LIMIT
----------------------------------------
COMPOSITE_LIMIT KERNEL
UNLIMITED

SESSIONS_PER_USER KERNEL
UNLIMITED

CPU_PER_SESSION KERNEL
UNLIMITED

RESOURCE_NAME RESOURCE
-------------------------------- --------
LIMIT
----------------------------------------
CPU_PER_CALL KERNEL
UNLIMITED

LOGICAL_READS_PER_SESSION KERNEL
UNLIMITED

LOGICAL_READS_PER_CALL KERNEL
UNLIMITED

RESOURCE_NAME RESOURCE
-------------------------------- --------
LIMIT
----------------------------------------
IDLE_TIME KERNEL
UNLIMITED

CONNECT_TIME KERNEL
UNLIMITED

PRIVATE_SGA KERNEL
UNLIMITED

RESOURCE_NAME RESOURCE
-------------------------------- --------
LIMIT
----------------------------------------
FAILED_LOGIN_ATTEMPTS PASSWORD
100000
SQL> select resource_name, limit from dba_profiles where resource_name = 'FAILED_LOGIN_ATTEMPTS';

RESOURCE_NAME                    LIMIT
-------------------------------- ----------------------------------------
FAILED_LOGIN_ATTEMPTS            100000
FAILED_LOGIN_ATTEMPTS            DEFAULT

SQL>
SQL> select username,account_status,profile from dba_users where username = 'JTITSM';

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
PROFILE
------------------------------
JTITSM OPEN
DEFAULT

ITPub博客

FAILED_LOGIN_ATTEMPTS

最新文章