Oracle 10g的PASSWORD_LIFE_TIME默认值为UNLIMITED
SYS@OCM10G >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@OCM11G >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@OCM11G >
alter profile default limit PASSWORD_LIFE_TIME UNLIMITED;
SYS@OCM11G >select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';
PROFILE RESOURCE_NAME RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
DEFAULT PASSWORD_LIFE_TIME PASSWORD UNLIMITED
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29047826/viewspace-1395543/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29047826/viewspace-1395543/