Debian Codegraph @

doc/src/sgml/ref/alter_user.sgml

raw
1 <!--
2 doc/src/sgml/ref/alter_user.sgml
3 PostgreSQL documentation
4 -->
5
6 <refentry id="sql-alteruser">
7 <indexterm zone="sql-alteruser">
8 <primary>ALTER USER</primary>
9 </indexterm>
10
11 <refmeta>
12 <refentrytitle>ALTER USER</refentrytitle>
13 <manvolnum>7</manvolnum>
14 <refmiscinfo>SQL - Language Statements</refmiscinfo>
15 </refmeta>
16
17 <refnamediv>
18 <refname>ALTER USER</refname>
19 <refpurpose>change a database role</refpurpose>
20 </refnamediv>
21
22 <refsynopsisdiv>
23 <synopsis>
24 ALTER USER <replaceable class="parameter">role_specification</replaceable> [ WITH ] <replaceable class="parameter">option</replaceable> [ ... ]
25
26 <phrase>where <replaceable class="parameter">option</replaceable> can be:</phrase>
27
28 SUPERUSER | NOSUPERUSER
29 | CREATEDB | NOCREATEDB
30 | CREATEROLE | NOCREATEROLE
31 | INHERIT | NOINHERIT
32 | LOGIN | NOLOGIN
33 | REPLICATION | NOREPLICATION
34 | BYPASSRLS | NOBYPASSRLS
35 | CONNECTION LIMIT <replaceable class="parameter">connlimit</replaceable>
36 | [ ENCRYPTED ] PASSWORD '<replaceable class="parameter">password</replaceable>' | PASSWORD NULL
37 | VALID UNTIL '<replaceable class="parameter">timestamp</replaceable>'
38
39 ALTER USER <replaceable class="parameter">name</replaceable> RENAME TO <replaceable>new_name</replaceable>
40
41 ALTER USER { <replaceable class="parameter">role_specification</replaceable> | ALL } [ IN DATABASE <replaceable class="parameter">database_name</replaceable> ] SET <replaceable>configuration_parameter</replaceable> { TO | = } { <replaceable>value</replaceable> | DEFAULT }
42 ALTER USER { <replaceable class="parameter">role_specification</replaceable> | ALL } [ IN DATABASE <replaceable class="parameter">database_name</replaceable> ] SET <replaceable>configuration_parameter</replaceable> FROM CURRENT
43 ALTER USER { <replaceable class="parameter">role_specification</replaceable> | ALL } [ IN DATABASE <replaceable class="parameter">database_name</replaceable> ] RESET <replaceable>configuration_parameter</replaceable>
44 ALTER USER { <replaceable class="parameter">role_specification</replaceable> | ALL } [ IN DATABASE <replaceable class="parameter">database_name</replaceable> ] RESET ALL
45
46 <phrase>where <replaceable class="parameter">role_specification</replaceable> can be:</phrase>
47
48 <replaceable class="parameter">role_name</replaceable>
49 | CURRENT_ROLE
50 | CURRENT_USER
51 | SESSION_USER
52 </synopsis>
53 </refsynopsisdiv>
54
55 <refsect1>
56 <title>Description</title>
57
58 <para>
59 <command>ALTER USER</command> is now an alias for
60 <link linkend="sql-alterrole"><command>ALTER ROLE</command></link>.
61 </para>
62 </refsect1>
63
64 <refsect1>
65 <title>Compatibility</title>
66
67 <para>
68 The <command>ALTER USER</command> statement is a
69 <productname>PostgreSQL</productname> extension. The SQL standard
70 leaves the definition of users to the implementation.
71 </para>
72 </refsect1>
73
74 <refsect1>
75 <title>See Also</title>
76
77 <simplelist type="inline">
78 <member><xref linkend="sql-alterrole"/></member>
79 </simplelist>
80 </refsect1>
81 </refentry>