ANBOB™

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> 

老用法不多解释

打赏

微信扫一扫，打赏作者吧～