ORA-28001:the password has expired.(密码失效)
程序员文章站
2022-04-25 21:19:00
...
ORA-28001:the password has expired.(密码失效),这个Oracle 11g新增的特性,默认用户密码只有180天有效期。
ORA-28001:the password has expired.(密码失效),这个Oracle 11g新增的特性,默认用户密码只有180天有效期。
1、plsql以管理员身份登陆,,system/admin(system默认密码为manager,我建库时候修改为admin)登陆
select username,account_status from dba_users; 可以看到有的用户状态为expired。
2、执行ALTER USER 用户名 IDENTIFIED BY 密码 ;
重新设置密码后,重新查询用户可以看到状态改为OPEN.
上一篇: Apache64位怎么载入Imagick
推荐阅读
-
ERROR 1862 (HY000): Your password has expired. To log in you must change it using a .....
-
Oracle密码过期问题 ORA-28001:the password has expired
-
密码过期:ORA-28001: the password has expired
-
oracle数据库修改密码有效期,解决ORA-28001: 口令已经失效
-
ORA-28001: the password has expired scott/tiger
-
解决"ORA-28001: the password has expired”
-
ORA-28001: the password has expired scott/tiger
-
ERROR 1862 (HY000): Your password has expired. To log in you must change it using a .....
-
Oracle密码过期问题 ORA-28001:the password has expired
-
ORA-28001: the password has expired 解决