본문 바로가기

Oracle/admin

패스워드 verify 설정 및 해제

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