The CREATE USER statement creates a new user account in a database.
User-name and
user-password here only refer to Pervasive PSQL databases and are not related to user names and passwords set at the operating system level. Pervasive PSQL user names, groups, and passwords can also be configured through the Pervasive PSQL Control Center (PCC).
The new user name is pgranger. The user’s password is NULL and the user account is not a member of any group.
The new user name is polly granger with non-alphanumeric characters. The user’s password is NULL and the user account is not a member of any group.
The new user name is pgranger. The user’s password is
Nonalfa$ (case-sensitive) with non-alphanumeric characters.
The new user name is pgranger. The new user account is a assigned to the group
developers.
The new user name is pgranger. The new user account is assigned to the group
developers and has the case-sensitive password
Prvsve1. The order of this syntax (
CREATE USER..WITH PASSWORD...IN GROUP) is absolutely necessary.