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 rolename [, ...]
    | IN GROUP rolename [, ...]
    | ROLE rolename [, ...]
    | ADMIN rolename [, ...]
    | USER rolename [, ...]
    | SYSID uid 

描述

CREATE GROUP 现在是 CREATE ROLE 的别名,参阅之获取更多信息。

兼容性

SQL 标准里没有 CREATE GROUP

又见

CREATE ROLE