CREATE GROUP

Defines a new database role.

Synopsis

  1. CREATE GROUP <name> [[WITH] <option> [ ... ]]

where option can be:

  1.       SUPERUSER | NOSUPERUSER
  2.     | CREATEDB | NOCREATEDB
  3.     | CREATEROLE | NOCREATEROLE
  4.     | CREATEUSER | NOCREATEUSER
  5.     | CREATEEXTTABLE | NOCREATEEXTTABLE 
  6.       [ ( <attribute>='<value>'[, ...] ) ]
  7.            where <attributes> and <value> are:
  8.            type='readable'|'writable'
  9.            protocol='gpfdist'|'http'
  10.     | INHERIT | NOINHERIT
  11.     | LOGIN | NOLOGIN
  12.     | CONNECTION LIMIT <connlimit>
  13.     | [ ENCRYPTED | UNENCRYPTED ] PASSWORD '<password>'
  14.     | VALID UNTIL '<timestamp>' 
  15.     | IN ROLE <rolename> [, ...]
  16.     | ROLE <rolename> [, ...]
  17.     | ADMIN <rolename> [, ...]
  18.     | RESOURCE QUEUE <queue_name>
  19.     | RESOURCE GROUP <group_name>
  20.     | [ DENY <deny_point> ]
  21.     | [ DENY BETWEEN <deny_point> AND <deny_point>]

Description

CREATE GROUP is an alias for CREATE ROLE.

Compatibility

There is no CREATE GROUP statement in the SQL standard.

See Also

CREATE ROLE

Parent topic: SQL Command Reference