===========
CREATE USER
===========


.. container:: refentry
   :name: SQL-CREATEUSER

   .. container:: titlepage

   .. container:: refnamediv

      .. rubric:: CREATE USER
         :name: create-user

      CREATE USER — 定义一个新的数据库角色

   .. container:: refsynopsisdiv

      .. rubric:: 大纲
         :name: 大纲

      .. code:: synopsis

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

         这里 option 可以是：

               SUPERUSER | NOSUPERUSER
             | CREATEDB | NOCREATEDB
             | CREATEROLE | NOCREATEROLE
             | 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

   .. container:: refsect1
      :name: id-1.9.3.95.5

      .. rubric:: 描述
         :name: 描述

      ``CREATE USER``\ 现在是 `CREATE
      ROLE <sql-createrole.html>`__\ 的一个别名。唯一的区别是
      ``CREATE USER``\ 中\ ``LOGIN`` 被作为默认值，而\ ``NOLOGIN``\ 是
      ``CREATE ROLE``\ 的默认值。

   .. container:: refsect1
      :name: id-1.9.3.95.6

      .. rubric:: 兼容性
         :name: 兼容性

      ``CREATE USER``\ 语句是一种 PostgreSQL扩展。SQL 标准
      把用户的定义留给实现来解释。

   .. container:: refsect1
      :name: id-1.9.3.95.7

      .. rubric:: 另见
         :name: 另见

      `CREATE ROLE <sql-createrole.html>`__