简体中文

CREATE USER

定义一个新的数据库角色。

概要

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

where option can be:
      SUPERUSER | NOSUPERUSER
    | CREATEDB | NOCREATEDB
    | CREATEROLE | NOCREATEROLE
    | CREATEEXTTABLE | NOCREATEEXTTABLE 
      [ ( <attribute>='<value>'[, ...] ) ]
           where <attributes> and <value> are:
           type='readable'|'writable'
           protocol='gpfdist'|'http'
    | INHERIT | NOINHERIT
    | LOGIN | NOLOGIN
    | REPLICATION | NOREPLICATION
    | BYPASSRLS | NOBYPASSRLS
    | CONNECTION LIMIT <connlimit>
    | [ ENCRYPTED ] PASSWORD '<password>' | PASSWORD NULL
    | VALID UNTIL '<timestamp>'
    | IN ROLE <role_name> [, ...]
    | IN GROUP <role_name>
    | ROLE <role_name> [, ...]
    | ADMIN <role_name> [, ...]
    | USER <role_name> [, ...]
    | SYSID <uid>
    | RESOURCE QUEUE <queue_name>
    | RESOURCE GROUP <group_name>
    | [ DENY <deny_point> ]
    | [ DENY BETWEEN <deny_point> AND <deny_point>]

描述

CREATE USER 是 CREATE ROLE 的别名。两者唯一的区别在于：当调用 CREATE USER 命令时，默认采用 LOGIN 模式；而当调用 CREATE ROLE 命令时，则默认采用 NOLOGIN 模式。

兼容性

CREATE USER 语句是数据库扩展功能。SQL 标准将用户的定义权交由具体实现决定。

另见

简体中文 English Русский

CREATE USER

概要

描述

兼容性

另见

简体中文

English

Русский