10GPASSWORD_REUSE_TIME和PASSWORD_REUSE_MAX这两个参数联合使用的效果

SQL> CREATE PROFILE sec_profile LIMIT PASSWORD_REUSE_TIME 1/1440     PASSWORD_REUSE_MAX  3 ;

Profile created.

SQL> SELECT   *    FROM   dba_profiles  WHERE   RESOURCE_NAME IN ('PASSWORD_REUSE_TIME', 'PASSWORD_REUSE_MAX') AND PROFILE = 'SEC_PROFILE';

PROFILE                        RESOURCE_NAME                    RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
SEC_PROFILE                    PASSWORD_REUSE_TIME              PASSWORD .0006
SEC_PROFILE                    PASSWORD_REUSE_MAX               PASSWORD 3

SQL> create user sec identified by sec;

User created.

SQL> grant connect to sec;

Grant succeeded.

SQL> alter user sec profile sec_profile;

User altered.

SQL> select USERNAME,PROFILE from dba_users where USERNAME = 'SEC';

USERNAME                       PROFILE
------------------------------ ------------------------------
SEC                            SEC_PROFILE

SQL> set time on
12:03:36 SQL> alter user sec identified by PassWord_1;

User altered.

12:03:45 SQL> alter user sec identified by PassWord_2;

User altered.

12:03:51 SQL> alter user sec identified by PassWord_0;

User altered.

12:04:00 SQL> alter user sec identified by sec;

User altered.

12:04:13 SQL> alter user sec identified by PassWord_1;
alter user sec identified by PassWord_1
*
ERROR at line 1:
ORA-28007: the password cannot be reused

12:05:15 SQL> alter user sec identified by PassWord_1;

User altered.

 

12:08:06 SQL> alter user sec identified by PassWord_0;
alter user sec identified by PassWord_0
*
ERROR at line 1:
ORA-28007: the password cannot be reused

12:08:07 SQL> alter user sec identified by PassWord_3;

User altered.

12:08:16 SQL> alter user sec identified by PassWord_0;

User altered.

提示已经重用过了

在超过1分钟的时限后，再次尝试重用密码“PassWord_0”，同样，无法完成修改任务 ，得改三次后，才能使用以前的密码。

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21158541/viewspace-668875/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21158541/viewspace-668875/