CREATE GROUP

Defines a new database role.

Synopsis

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

where option can be:

         SUPERUSER | NOSUPERUSER
       | CREATEDB | NOCREATEDB
       | CREATEROLE | NOCREATEROLE
       | CREATEUSER | NOCREATEUSER
       | CREATEEXTTABLE | NOCREATEEXTTABLE
         [ ( <attribute>='<value>'[, ...] ) ]
               where <attributes> and <value> are:
               type='readable'|'writable'
               protocol='gpfdist'|'http'

      | INHERIT | NOINHERIT
      | LOGIN | NOLOGIN
      | CONNECTION LIMIT <connlimit>
      | [ ENCRYPTED | UNENCRYPTED ] PASSWORD '<password>'
      | VALID UNTIL '<timestamp>'
      | IN ROLE <rolename> [, ...]
      | ROLE <rolename> [, ...]
      | ADMIN <rolename> [, ...]
      | RESOURCE QUEUE <queue_name>
      | RESOURCE GROUP <group_name>
      | [ DENY <deny_point> ]
      | [ 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