CREATE USER

CREATE USER

7

SQL - Language Statements

CREATE USER

define a new database role

CREATE USER

name

\[ \[ WITH \]

option

\[ \... \] \]

where

option

can be:

SUPERUSER \| NOSUPERUSER \| CREATEDB \| NOCREATEDB \| CREATEROLE \|
NOCREATEROLE \| 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

Description
===========

`CREATE USER` is now an alias for [`CREATE ROLE`](#sql-createrole). The
only difference is that when the command is spelled `CREATE USER`,
`LOGIN` is assumed by default, whereas `NOLOGIN` is assumed when the
command is spelled `CREATE ROLE`.

Compatibility
=============

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

See Also
========
