oracle11g - Cannot create Oracle user with specific password -
in oracle tried query
create user act_app identified password profile app_profile default tablespace ts_module_d temporary tablespace temp;
after sending query , got these 2 errors.
- password verification specified password failed
- password should contain @ least 1 digit, 1 character , 1 punctuation
so modified query to
create user act_app identified !234qwer profile app_profile default tablespace ts_module_d temporary tablespace temp;
but got error
missing or invalid option
passwords must follow rules described in section "database object naming rules"
!234qwer
not valid object name because of leading !
therefor needs enclosed in double quotes:
create user act_app identified "!234qwer" profile app_profile default tablespace ts_module_d temporary tablespace temp;
Comments
Post a Comment