oracel 用户密码过期修改

1. 修改用户密码

alter user username identified by "new password";

2. 查看默认密码的有效期

SELECT * FROM dba_profiles WHERE profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';

3. 修改默认密码有效期为永久不过期

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;