重庆思庄Oracle、Redhat认证学习论坛

标题: Oracle10g与Oracle11g中PASSWORD_LIFE_TIME的差异 [打印本页]

作者: 刘泽宇 时间: 2021-11-21 17:06
标题: Oracle10g与Oracle11g中PASSWORD_LIFE_TIME的差异
Oracle 10g的PASSWORD_LIFE_TIME默认值为UNLIMITED

SYS@ORCL10G >select * from dba_profiles where profile='DEFAULT' and RESOURCE_NAME='PASSWORD_LIFE_TIME';

PROFILE                      RESOURCE_NAME                   RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
DEFAULT                      PASSWORD_LIFE_TIME             PASSWORD UNLIMITED

Oracle11g的PASSWORD_LIFE_TIME默认值为180天

SYS@ORCL11G >select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';

PROFILE                      RESOURCE_NAME                   RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
DEFAULT                      PASSWORD_LIFE_TIME             PASSWORD 180

安装11G数据库后如果忽略该参数的的有效期变为180天，那么半年之后用户就无法登录了。在这里可以手工修改为无限（UNLIMITED）

SYS@ORCL11G >alter profile default limit PASSWORD_LIFE_TIME UNLIMITED;

SYS@ORCL11G >select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';

PROFILE                      RESOURCE_NAME                   RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
DEFAULT                      PASSWORD_LIFE_TIME             PASSWORD UNLIMITED

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)