==========
ALTER USER
==========


.. container:: refentry
   :name: SQL-ALTERUSER

   .. container:: titlepage

   .. container:: refnamediv

      .. rubric:: ALTER USER
         :name: alter-user

      ALTER USER — 更改一个数据库角色

   .. container:: refsynopsisdiv

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

      .. code:: synopsis

         ALTER USER role_specification [ 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'

         ALTER USER name RENAME TO new_name

         ALTER USER { role_specification | ALL } [ IN DATABASE database_name ] SET configuration_parameter { TO | = } { value | DEFAULT }
         ALTER USER { role_specification | ALL } [ IN DATABASE database_name ] SET configuration_parameter FROM CURRENT
         ALTER USER { role_specification | ALL } [ IN DATABASE database_name ] RESET configuration_parameter
         ALTER USER { role_specification | ALL } [ IN DATABASE database_name ] RESET ALL

         其中 role_specification 可以是：

             role_name
           | CURRENT_USER
           | SESSION_USER

   .. container:: refsect1
      :name: id-1.9.3.43.5

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

      ``ALTER USER``\ 现在是 `ALTER
      ROLE <sql-alterrole.html>`__\ 的一种别名。

   .. container:: refsect1
      :name: id-1.9.3.43.6

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

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

   .. container:: refsect1
      :name: id-1.9.3.43.7

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

      `ALTER ROLE <sql-alterrole.html>`__