CREATE USER

CREATE USER adds a name to the list of authorized database users.

Syntax

CREATE USER name [ WITH [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password' ]

Semantics

name	specifies the name of the user to create; names that contain special characters must be double-quoted.
ENCRYPTED	is the default.
password	is the password to assign to the user.

Notes

User names are not case-sensitive.
The following options are allowed but ignored:
- SYSID uid
- CREATEDB
- NOCREATEDB
- CREATEUSER
- NOCREATEUSER
- VALID UNTIL
Other options, including IN GROUP, are not allowed.
Newly-created users do not have access to schema PUBLIC by default. Make sure to GRANT USAGE ON SCHEMA PUBLIC to all users you create.

Examples

CREATE USER Fred;

GRANT USAGE ON SCHEMA PUBLIC to Fred;