PASSWORD_REUSE_TIME and PASSWORD_REUSE_MAX

http://docs.oracle.com/database/121/SQLRF/statements_6012.htm#SQLRF01310

PASSWORD_REUSE_TIME and PASSWORD_REUSE_MAX  These two parameters must be set in conjunction with each other. PASSWORD_REUSE_TIME specifies the number of days before which a password cannot be reused. PASSWORD_REUSE_MAX specifies the number of password changes required before the current password can be reused. For these parameter to have any effect, you must specify a value for both of them.
PASSWOR_REUSE_TIME和PASSWORD_REUSE_MAX 这两个参数是同时使用的. PASSWORD_REUSE_TIME指定的是密码在多少天之后才可以被重用.PASSWORD_REUSE_MAX指密码在修改多少次之后才可以重用. 对于这些参数所带来效果,必须同时使用                                                                                                                        

• If you specify a value for both of these parameters, then the user cannot reuse a password until the password has been changed the number of times specified for PASSWORD_REUSE_MAX during the number of days specified for PASSWORD_REUSE_TIME.
  如果你指定这两个参数,那么用户知道密码已经按照PASSWORD_REUSE_MAX的次数以后才可以重用之前用过的密码

  For example, if you specify PASSWORD_REUSE_TIME to 30 and PASSWORD_REUSE_MAX to 10, then the user can reuse the password after 30 days if the password has already been changed 10 times.
  举例来说,如果你指定PASSWORD_REUSE_TIME为30天并且PASSWORD_REUSE_MAX为10,那么用户只有才30天之后并且密码以及国内变更过10次以后才可以重用之前的密码

• If you specify a value for either of these parameters and specify UNLIMITED for the other, then the user can never reuse a password.
  如果你仅仅指定了其中一个参数然后设置另外一个参数为UNLIMTED,那么用户是不可能重用密码的

• If you specify DEFAULT for either parameter, then Oracle Database uses the value defined in the DEFAULT profile. By default, all parameters are set to UNLIMITED in the DEFAULT profile. If you have not changed the default setting of UNLIMITED in the DEFAULT profile, then the database treats the value for that parameter as UNLIMITED.
  如果你设置了默认值,则ORACLE使用在DEFAULT PROFILE里面的默认值.默认情况下,所有的参数在 PROFILE里面都是默认值.如果你不变更他们的默认值DEFAULT,则数据库默认使用UNLIMITED

• If you set both of these parameters to UNLIMITED, then the database ignores both of them. This is the default if you omit both parameters.
  如果都设置为UNLIMITED,则数据库忽略这个参数

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

转载于:http://blog.itpub.net/8747612/viewspace-1971504/