CREATE GROUP

Name

CREATE GROUP -- 定义一个新数据库角色

Synopsis

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语句。

又见

CREATE ROLE