2014. 5. 28. 15:10 오라클
11g password 복잡도 해제
패스워드 복잡성 때문에 유저 생성시 에러가 난다면..
ORA-28003: password verification for the specified password failed
ORA-20006: Password too simple
1.Disable password validation
SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_VERIFY_FUNCTION NULL;
2. Enable the password validation:
SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_VERIFY_FUNCTION verify_function_11G;
