SQL> create user hhh identified by hhh;
create user hhh identified by hhh
*
ERROR at line 1:
ORA-28003: password verification for the specified password failed
ORA-20001: Password length less than 8
SQL> alter profile default limit password_verify_function null;
Profile altered.
SQL> create user hhh identified by hhh;
User created.
==================================================
password validation
-해제
alter profile default limit password_verify_function null;
-설정
alter profile default limit password_verify_function verify_function_11g;
'Oracle > admin' 카테고리의 다른 글
Dataguard Switchover (0) | 2016.06.16 |
---|---|
Oracle Dataguard Install (0) | 2016.06.16 |
Oracle TDE (0) | 2016.06.14 |
batch 파일중 SQL 부하 찾기 (0) | 2016.06.13 |
Migration Step (0) | 2016.06.13 |