以Oracle用户登陆,输入以下命令查询密码有效期
select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';
然后修改密码期限
alter profile default limit password_life_time unlimited;
commit;
再次查询
select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';
修改密码命令
alter user XXXUSER identified by Welcome1;
如果账号被锁住,则需要解锁命令
alter user XXXUSER identified by oracle account unlock;
Oracle密码过期处理方法
最新推荐文章于 2024-07-18 11:10:50 发布