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;
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;