Oracle ORA-28002: the password will expire within 10 days

oracle ORA-28002: the password will expire within 10 days解決方法如下 1、查詢此用戶的perfile文件 select username,profile from dba_users where username=SCOTT; 2、根據文件名查詢值 select * from dba_profiles where profile=DEFAULT; – 3、修改密

Oracle ORA-28002: the password will expire within 10 days解決方法如下

1、查詢此用戶的perfile文件

select username,profile from dba_users where username=’SCOTT’;

2、根據文件名查詢值

select * from dba_profiles where profile=’DEFAULT’;
–

3、修改密碼過期時間password_life_time? 為unlimited

alter profile default limit password_life_time unlimited;

4、查詢密碼復雜度驗證 PASSWORD_VERIFY_FUNCTION? VERIFY_FUNCTION

alter profile default limit PASSWORD_VERIFY_FUNCTION? NULL;(不采用復雜度驗證)

5、修改密碼為原來密碼

alter user scott identified by tiger;?

上面修改默認的值可能會影響其他,建議創建一個perfile文件 綁定到用戶