今天创建数据库用户失败,提示ORA-28003,发现PROFILE里有PASSWORD_VERIFY_FUNCTION设置,修改后再次创建用户成功。
SQL>create user oracle identified by oracle;
create user oracle identified by oracle
*
ERROR at line 1:
ORA-28003: password verification for the specified password failed
ORA-20001: Password same as or similar to user
SQL>alter profile default limit password_verify_function null;
Profile altered.
SQL>create user oracle identified by oracle;
User created.