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.

  1. password verification specified password failed
  2. 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

from manual:

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

Popular posts from this blog

qt - Using float or double for own QML classes -

Create Outlook appointment via C# .Net -

ios - Swift Array Resetting Itself -