Hi All,
here in my 11g Db iam setting user password same as user name but not able to set getting error .
Please help on this :
SQL> ALTER USER test IDENTIFIED BY test;
ALTER USER test IDENTIFIED BY test
*
ERROR at line 1:
ORA-28003: password verification for the specified password failed
ORA-20001: Password same as or similar to user
SQL> select profile, resource_name, limit from dba_profiles where resource_type = 'PASSWORD';
PROFILE RESOURCE_NAME LIMIT
------------------------------ -------------------------------- ----------------------------------------
USER_PROFILE FAILED_LOGIN_ATTEMPTS DEFAULT
SERVICE_PROFILE FAILED_LOGIN_ATTEMPTS UNLIMITED
DEFAULT FAILED_LOGIN_ATTEMPTS 10
USER_PROFILE PASSWORD_LIFE_TIME DEFAULT
SERVICE_PROFILE PASSWORD_LIFE_TIME UNLIMITED
DEFAULT PASSWORD_LIFE_TIME 180
USER_PROFILE PASSWORD_REUSE_TIME DEFAULT
SERVICE_PROFILE PASSWORD_REUSE_TIME UNLIMITED
DEFAULT PASSWORD_REUSE_TIME UNLIMITED
USER_PROFILE PASSWORD_REUSE_MAX DEFAULT
SERVICE_PROFILE PASSWORD_REUSE_MAX UNLIMITED
PROFILE RESOURCE_NAME LIMIT
------------------------------ -------------------------------- ----------------------------------------
DEFAULT PASSWORD_REUSE_MAX UNLIMITED
USER_PROFILE PASSWORD_VERIFY_FUNCTION VERIFY_FUNCTION
SERVICE_PROFILE PASSWORD_VERIFY_FUNCTION NULL
DEFAULT PASSWORD_VERIFY_FUNCTION NULL
USER_PROFILE PASSWORD_LOCK_TIME DEFAULT
SERVICE_PROFILE PASSWORD_LOCK_TIME UNLIMITED
DEFAULT PASSWORD_LOCK_TIME 1
USER_PROFILE PASSWORD_GRACE_TIME DEFAULT
SERVICE_PROFILE PASSWORD_GRACE_TIME UNLIMITED
DEFAULT PASSWORD_GRACE_TIME 7