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博客 ” ，链接：https://blog.itpub.net/21158541/viewspace-668875/ ，如需转载，请注明出处，否则将追究法律责任。
