首页 » ORACLE » oracle profile 登录失败次数

oracle profile 登录失败次数

SQL> create profile log5 limit FAILED_LOGIN_ATTEMPTS 5;

Profile created.

SQL> alter user anbob profile log5;

User altered.

SQL> conn anbob/asd
ERROR:
ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.
SQL> conn anbob/asd
ERROR:
ORA-01017: invalid username/password; logon denied

SQL> conn anbob/asd
ERROR:
ORA-01017: invalid username/password; logon denied

SQL> conn anbob/asd
ERROR:
ORA-01017: invalid username/password; logon denied

SQL> conn anbob/asd
ERROR:
ORA-01017: invalid username/password; logon denied

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

SQL> conn system/oracle
Connected.
SQL> alter user anbob account unlock;

User altered.

 ALTER PROFILE
 -------------

 Use this command to add, modify, or remove a resource limit or
 password management in a profile.

 ALTER PROFILE profile LIMIT
   { { SESSIONS_PER_USER
     | CPU_PER_SESSION
     | CPU_PER_CALL
     | CONNECT_TIME
     | IDLE_TIME
     | LOGICAL_READS_PER_SESSION
     | LOGICAL_READS_PER_CALL
     | COMPOSITE_LIMIT}
        {integer | UNLIMITED | DEFAULT}
   | { PRIVATE_SGA { integer [K | M]
                   | UNLIMITED
                   | DEFAULT}
   | FAILED_LOGIN_ATTEMPTS
   | PASSWORD_LIFETIME
   | {PASSWORD_REUSE_TIME
     |PASSWORD_REUSE_MAX}
   | ACCOUNT_LOCK_TIME
   | PASSWORD_GRACE_TIME}
       {integer | UNLIMITED | DEFAULT}
   | PASSWORD_VERIFY_FUNCTION
       {function | NULL | DEFAULT} } ...

 For detailed information on this command, see the Oracle8 Server SQL
 Reference.

SQL> alter profile log5 limit failed_login_attempts 3;

Profile altered.

SQL> conn anbob/dd
ERROR:
ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.
SQL> conn anbob/dd
ERROR:
ORA-01017: invalid username/password; logon denied

SQL> conn anbob/dd
ERROR:
ORA-01017: invalid username/password; logon denied

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

SQL> alter profile log5 limit failed_login_attempts unlimited;
SP2-0640: Not connected
SQL> conn system/oracle
Connected.
SQL> alter profile log5 limit failed_login_attempts unlimited;

Profile altered.

SQL> 

老用法不多解释
打赏

目前这篇文章有1条评论(Rss)评论关闭。

  1. Stefany Cheverton | #1
    2011-12-21 at 04:12

    Thanks for taking the time to post this article. It is always educating to read someones perspective.