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 Commands