Vantage requires you to associate a username with a password when you first create a user. You must specify a password, even if temporary. Otherwise, the Parser rejects the statement as incomplete.
The security administrator can prompt users for a new password on first logon for these reasons:
- When installing a new system, the administrator has created generic passwords for all users and wants the users to choose their own passwords.
- New password requirements must be enforced. For example, if the security administrator wants to require mixed case and wants all users to change their passwords.
To use SQL, see “PASSWORD” in CREATE USER Syntax Elements.