oracle 登录失败次数,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>

老用法不多解释