CREATE GROUP

CREATE GROUP

7

SQL - Language Statements

CREATE GROUP

define a new database role

CREATE GROUP

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 GROUP` is now an alias for [???](#sql-createrole).

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

There is no `CREATE GROUP` statement in the SQL standard.

See Also
========
