Oracle提示错误消息ORA-28001: the password has expired
来源:互联网 发布:旋风十一人 知乎 编辑:程序博客网 时间:2024/06/13 16:46
Oracle提示错误消息ORA-28001: the password has expired,
经调查是由于Oracle11G的新特性所致, Oracle11G创建用户时缺省密码过期限制是180天, 如果超过180天用户密码未做修改则该用户无法登录。
可通过
SELECT * FROM dba_profiles WHERE profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME'
语句查询密码的有效期设置,
LIMIT字段是密码有效天数。在密码将要过期或已经过期时可通过
ALTER USER 用户名 IDENTIFIED BY 密码 ;
语句进行修改密码,密码修改后该用户可正常连接数据库。
长久对应可通过
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED
语句将口令有效期默认值180天修改成“无限制”。出于数据库安全性考虑,不建议将PASSWORD_LIFE_TIME值设置成UNLIMITED,
建议客户定期修改数据库用户口令。
- Oracle提示错误消息ORA-28001: the password has expired
- Oracle提示错误消息ORA-28001: the password has expired
- Oracle提示错误消息ORA-28001: the password has expired
- Oracle提示错误消息ORA-28001: the password has expired
- Oracle提示错误消息ORA-28001: the password has expired
- Oracle提示错误消息ORA-28001: the password has expired的解决方法
- Oracle ORA-28001: the password has expired
- Oracle报错,ORA-28001:the password has expired
- ORA-28001: the password has expired Oracle 密码过期
- Oracle密码过期ORA-28001: the password has expired解决办法
- ORA-28001: the password has expired
- 解决"ORA-28001: the password has expired”
- ORA-28001: the password has expired
- ORA-28001: the password has expired
- 解决"ORA-28001: the password has expired”
- ORA-28001: the password has expired .
- ORA-28001: the password has expired
- ORA-28001: the password has expired
- File Delete Absolutely was granted with 100% CLEAN Softpedia award
- configure: error: pkg-config and "glib-2.0 >= 2.16" not found, please set GLIB_CFLAGS and GLIB_LIBS
- SQL Server 2008自动备份
- QGraphics的使用方法概述
- 简明x86汇编语言教程(2)
- Oracle提示错误消息ORA-28001: the password has expired
- 报错:failed to get the task for process XXX(解决方案)
- 学习HTML5安全–资源列表
- MyEclipse加入jquery.js文件missing semicolon的错误
- arduino LWIP 向yeelink增加一个数据点的实例
- 利用instrument+Attach API+javassist动态改变方法逻辑
- PL/SQL格式化SQL语句, 选中行高亮,双击即显示表数据,特殊Copy 等技巧
- 长时间停留在calculating requirements and dependencies 的解决方案
- 如何生成 动态库 和 静态库