报错信息:
解决办法:
SELECT USERNAME,ACCOUNT_STATUS,PROFILE FROM DBA_USERS WHERE USERNAME=’TESTUSET’;
SQL> SELECT USERNAME,ACCOUNT_STATUS,PROFILE FROM DBA_USERS WHERE USERNAME='TESTUSER';
no rows selected
SQL> SELECT * FROM DBA_PROFILES WHERE PROFILE='DEFAULT';
...
DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD
UNLIMITED
DEFAULT PASSWORD_LIFE_TIME PASSWORD
180--------------------------------------------------------------------此处显示为180天过期
DEFAULT PASSWORD_REUSE_TIME PASSWORD
UNLIMITED
PROFILE RESOURCE_NAME RESOURCE
....
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
Profile altered.
注意:
不需要重启理立刻生效