Skip to main content

CREATE USER

Defines a new database role.

Synopsis

CREATE USER <name> [[WITH] <option> [ ... ]]

where option can be:
SUPERUSER | NOSUPERUSER
| CREATEDB | NOCREATEDB
| CREATEROLE | NOCREATEROLE
    | CREATEEXTTABLE | NOCREATEEXTTABLE
      [ ( <attribute>='<value>'[, ...] ) ]
           where <attributes> and <value> are:
           type='readable'|'writable'
           protocol='gpfdist'|'http'
| INHERIT | NOINHERIT
| LOGIN | NOLOGIN
| REPLICATION | NOREPLICATION
| BYPASSRLS | NOBYPASSRLS
| CONNECTION LIMIT <connlimit>
| [ ENCRYPTED ] PASSWORD '<password>' | PASSWORD NULL
| VALID UNTIL '<timestamp>'
| IN ROLE <role_name> [, ...]
| IN GROUP <role_name>
| ROLE <role_name> [, ...]
| ADMIN <role_name> [, ...]
| USER <role_name> [, ...]
| SYSID <uid>
    | RESOURCE QUEUE <queue_name>
    | RESOURCE GROUP <group_name>
| [ DENY <deny_point> ]
| [ DENY BETWEEN <deny_point> AND <deny_point>]

Description

CREATE USER is an alias for CREATE ROLE. The only difference is that when the command CREATE USER is invoked, LOGIN is assumed by default, whereas NOLOGIN is assumed when the command invoked is CREATE ROLE.

Compatibility

The CREATE USER statement is a Cloudberry Database extension. The SQL standard leaves the definition of users to the implementation.

See also

CREATE ROLE