CREATE GROUP

名称

大纲

CREATE GROUP name [ [ WITH ] option [ ... ] ]
这里的option可以是:
 SUPERUSER | NOSUPERUSER
 | CREATEDB | NOCREATEDB
 | CREATEROLE | NOCREATEROLE
 | CREATEUSER | NOCREATEUSER
 | INHERIT | NOINHERIT
 | LOGIN | NOLOGIN
 | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'
 | VALID UNTIL 'timestamp'
 | IN ROLE role_name [, ...]
 | IN GROUP role_name [, ...]
 | ROLE role_name [, ...]
 | ADMIN role_name [, ...]
 | USER role_name [, ...]
 | SYSID uid

描述

CREATE GROUP现在是CREATE ROLE的一个别名。

兼容性

SQL标准里并没有 CREATE GROUP语句。

又见