暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

oracle profile 登录失败次数

原创 Anbob 2011-05-27
619
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>
老用法不多解释
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论