(ORACLE) create user 오류 : 누락된 또는 부적합한 옵션

creat user 시 아래 오류 발생

create user userName identified by !!pwd



-- SQL Error [922] [42000]: ORA-00922: 누락된 또는 부적합한 옵션

 

 

 

오라클 password 정책 확인

o Passwords must be from 1 to 30 characters long.
o Passwords cannot contain quotation marks.
o Passwords are not case sensitive.
o A Password must begin with an alphabetic character.
o Passwords can contain only alphanumeric characters and the underscore (_), dollar sign ($), and pound sign (#). Oracle strongly discourages you from using $ and #..
o A Password cannot be an Oracle reserved word (eg: SELECT).

 

원인은 알파벳으로 시작해야하는 정책을 지키지 않은 것이었다.