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;