开发人员发来报错：

SQL> alter user cinter identified by cinter;

alter user cinter identified by  cinter

ORA-28003: 指定口令的口令验证失败
ORA-20001: Password same as or similar to user

说密码不能和用户名相同。但是给了密码后报：

alter user cinter identified by  cinter123

ORA-28003: 指定口令的口令验证失败
ORA-20003: Password should contain at least one \
              digit, one character and one punctuation

检查是知道ORACLE启用了密码验证函数。

实验结果如下：

SQL> @utlpwdmg.sql

函数已创建。

配置文件已更改

函数已创建。

SQL> alter user sunxin identified by sunxin;

alter user sunxin identified by sunxin

*

第 1 行出现错误:

ORA-28003: 指定口令的口令验证失败

ORA-20001: Password length less than 8

SQL> alter user sunxin identified by sunxin123;

用户已更改。

SQL> alter profile default limit password_verify_function verify_function;

配置文件已更改

SQL> alter user sunxin identified by sunxin;

alter user sunxin identified by sunxin

*

第 1 行出现错误:

ORA-28003: 指定口令的口令验证失败

ORA-20001: Password same as or similar to user

SQL> alter user sunxin identified by sunxin123;

alter user sunxin identified by sunxin123

*

第 1 行出现错误:

ORA-28003: 指定口令的口令验证失败

ORA-20003: Password should contain at least one \

digit, one character and one punctuation

SQL> alter user sunxin identified by sunxin123 replace sunxin;

alter user sunxin identified by sunxin123 replace sunxin

*

第 1 行出现错误:

ORA-28003: 指定口令的口令验证失败

ORA-20003: Password should contain at least one \

digit, one character and one punctuation

SQL> alter user sunxin identified by sunxin replace sunxin123;

alter user sunxin identified by sunxin replace sunxin123

*

第 1 行出现错误:

ORA-28003: 指定口令的口令验证失败

ORA-20001: Password same as or similar to user

SQL> alter user sunxin identified by sunxin replace sunxin123;

alter user sunxin identified by sunxin replace sunxin123

*

第 1 行出现错误:

ORA-28003: 指定口令的口令验证失败

ORA-20001: Password same as or similar to user

SQL> conn sunxin/sunxin123

已连接。

SQL> password

更改 SUNXIN 的口令

旧口令:

新口令:

重新键入新口令:

ERROR:

ORA-28003: 指定口令的口令验证失败

ORA-20001: Password same as or similar to user

口令未更改

ITPub博客

ORACLE 密码验证函数

最新文章