1.查看概要文件密码有效期设置：http://www.cndba.cn/hbhe0316/article/107907

SQL> SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';

PROFILE
--------------------------------------------------------------------------------
RESOURCE_NAME
--------------------------------------------------------------------------------
RESOURCE_TYPE
------------------------
LIMIT
--------------------------------------------------------------------------------
COMMON    INHERITED IMPLICIT
--------- --------- ---------
DEFAULT
PASSWORD_LIFE_TIME
PASSWORD

PROFILE
--------------------------------------------------------------------------------
RESOURCE_NAME
--------------------------------------------------------------------------------
RESOURCE_TYPE
------------------------
LIMIT
--------------------------------------------------------------------------------
COMMON    INHERITED IMPLICIT
--------- --------- ---------
180
NO        NO        NO

2.如果密码有效期被设置为180天，那么将需要进行如下修改：

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

Profile altered.

3.再次查看是否为UNLIMITEDhttp://www.cndba.cn/hbhe0316/article/107907

SQL> SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';

PROFILE
--------------------------------------------------------------------------------
RESOURCE_NAME
--------------------------------------------------------------------------------
RESOURCE_TYPE
------------------------
LIMIT
--------------------------------------------------------------------------------
COMMON    INHERITED IMPLICIT
--------- --------- ---------
DEFAULT
PASSWORD_LIFE_TIME
PASSWORD

PROFILE
--------------------------------------------------------------------------------
RESOURCE_NAME
--------------------------------------------------------------------------------
RESOURCE_TYPE
------------------------
LIMIT
--------------------------------------------------------------------------------
COMMON    INHERITED IMPLICIT
--------- --------- ---------
UNLIMITED
NO        NO        NO

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle