oracle数据库用户密码默认为180天，密码过期后将无法登陆数据库。文章来源地址:https://www.yii666.com/article/758051.html
一、查询用户所属PROFILE
SQL> SELECT username,PROFILE FROM dba_users;
USERNAME PROFILE
------------------------------ ------------------------------
MGMT_VIEW DEFAULT
SYS DEFAULT
SYSTEM DEFAULT
DBSNMP MONITORING_PROFILE
SYSMAN DEFAULT
SA DEFAULT
OGG DEFAULT
一般都是默认DEFAULT文章地址https://www.yii666.com/article/758051.html网址:yii666.com
一、查询用户密码有效期
SQL> SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME'; PROFILE RESOURCE_NAME RESOURCE LIMIT
--------- ------------------- ------------- ----------------
DEFAULT PASSWORD_LIFE_TIME PASSWORD 180
三、将用户密码有效期设为无限期
SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; PROFILE RESOURCE_NAME RESOURCE LIMIT
--------- ------------------- ------------- ----------------
DEFAULT PASSWORD_LIFE_TIME PASSWORD UNLIMITED