Oracle提示错误消息ORA-28001: the password has expired 解决办法: 1、利用SYSDBA权限登陆; 2、查看账户信息: select username,account_status from dba_users 3、如果账户locked/ expired, 得先解锁: alter user BJMMIS account unlock; 再修改密码 a
解决办法:
1、利用SYSDBA权限登陆;
2、查看账户信息:
select username,account_status from dba_users
3、如果账户locked/expired,
得先解锁:
alter user BJMMIS account unlock;
再修改密码
alter user BJMMIS identified by newpwd;
一劳永逸破解11G180天自动密码失效的办法:
查询密码有效期
SELECT * FROM dba_profiles WHERE profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME'
修改为无:
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED
Copyright © 2019- igbc.cn 版权所有 湘ICP备2023023988号-5
违法及侵权请联系:TEL:199 1889 7713 E-MAIL:2724546146@qq.com
本站由北京市万商天勤律师事务所王兴未律师提供法律服务