Each CREATE USER statement must specify a user password. The initial password assignment is temporary and set to expire at first logon, after which users create their own password.
Passwords must conform to default system password format requirements and any password controls that affect password structure. See About Password Controls.
The system validates each password against default format requirements and settable format controls. An error message results whenever a password violates a password format rule.