Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit3dab288

Browse files
committed
Clarify documentation about PASSWORD in CREATE/ALTER ROLE
The documentation of CREATE/ALTER ROLE has been missing two thingsrelated to PASSWORD:- The password value provided needs to be quoted, some places of thedocumentation marked the field with quotes, but not others, which led toconfusion.- PASSWORD NULL was not provided consistently, with ENCRYPTED being notcompatible with it.Reported-by: Steven WinfieldAuthor: Michael PaquierReviewed-by: David G. JohnstonDiscussion:https://postgr.es/m/154282901979.1316.7418475422120496802@wrigleys.postgresql.org
1 parent595220a commit3dab288

File tree

4 files changed

+8
-6
lines changed

4 files changed

+8
-6
lines changed

‎doc/src/sgml/ref/alter_role.sgml‎

Lines changed: 3 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -33,7 +33,7 @@ ALTER ROLE <replaceable class="parameter">role_specification</replaceable> [ WIT
3333
| REPLICATION | NOREPLICATION
3434
| BYPASSRLS | NOBYPASSRLS
3535
| CONNECTION LIMIT <replaceable class="parameter">connlimit</replaceable>
36-
| [ ENCRYPTED ] PASSWORD '<replaceable class="parameter">password</replaceable>'
36+
| [ ENCRYPTED ] PASSWORD '<replaceable class="parameter">password</replaceable>' | PASSWORD NULL
3737
| VALID UNTIL '<replaceable class="parameter">timestamp</replaceable>'
3838

3939
ALTER ROLE <replaceable class="parameter">name</replaceable> RENAME TO <replaceable>new_name</replaceable>
@@ -168,7 +168,8 @@ ALTER ROLE { <replaceable class="parameter">role_specification</replaceable> | A
168168
<term><literal>BYPASSRLS</literal></term>
169169
<term><literal>NOBYPASSRLS</literal></term>
170170
<term><literal>CONNECTION LIMIT</literal> <replaceable class="parameter">connlimit</replaceable></term>
171-
<term>[ <literal>ENCRYPTED</literal> ] <literal>PASSWORD</literal> <replaceable class="parameter">password</replaceable></term>
171+
<term>[ <literal>ENCRYPTED</literal> ] <literal>PASSWORD</literal> '<replaceable class="parameter">password</replaceable>'</term>
172+
<term><literal>PASSWORD NULL</literal></term>
172173
<term><literal>VALID UNTIL</literal> '<replaceable class="parameter">timestamp</replaceable>'</term>
173174
<listitem>
174175
<para>

‎doc/src/sgml/ref/alter_user.sgml‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -33,7 +33,7 @@ ALTER USER <replaceable class="parameter">role_specification</replaceable> [ WIT
3333
| REPLICATION | NOREPLICATION
3434
| BYPASSRLS | NOBYPASSRLS
3535
| CONNECTION LIMIT <replaceable class="parameter">connlimit</replaceable>
36-
| [ ENCRYPTED ] PASSWORD '<replaceable class="parameter">password</replaceable>'
36+
| [ ENCRYPTED ] PASSWORD '<replaceable class="parameter">password</replaceable>' | PASSWORD NULL
3737
| VALID UNTIL '<replaceable class="parameter">timestamp</replaceable>'
3838

3939
ALTER USER <replaceable class="parameter">name</replaceable> RENAME TO <replaceable>new_name</replaceable>

‎doc/src/sgml/ref/create_role.sgml‎

Lines changed: 3 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -33,7 +33,7 @@ CREATE ROLE <replaceable class="parameter">name</replaceable> [ [ WITH ] <replac
3333
| REPLICATION | NOREPLICATION
3434
| BYPASSRLS | NOBYPASSRLS
3535
| CONNECTION LIMIT <replaceable class="parameter">connlimit</replaceable>
36-
| [ ENCRYPTED ] PASSWORD '<replaceable class="parameter">password</replaceable>'
36+
| [ ENCRYPTED ] PASSWORD '<replaceable class="parameter">password</replaceable>' | PASSWORD NULL
3737
| VALID UNTIL '<replaceable class="parameter">timestamp</replaceable>'
3838
| IN ROLE <replaceable class="parameter">role_name</replaceable> [, ...]
3939
| IN GROUP <replaceable class="parameter">role_name</replaceable> [, ...]
@@ -210,7 +210,8 @@ CREATE ROLE <replaceable class="parameter">name</replaceable> [ [ WITH ] <replac
210210
</varlistentry>
211211

212212
<varlistentry>
213-
<term>[ <literal>ENCRYPTED</literal> ] <literal>PASSWORD</literal> <replaceable class="parameter">password</replaceable></term>
213+
<term>[ <literal>ENCRYPTED</literal> ] <literal>PASSWORD</literal> '<replaceable class="parameter">password</replaceable>'</term>
214+
<term><literal>PASSWORD NULL</literal></term>
214215
<listitem>
215216
<para>
216217
Sets the role's password. (A password is only of use for

‎doc/src/sgml/ref/create_user.sgml‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -33,7 +33,7 @@ CREATE USER <replaceable class="parameter">name</replaceable> [ [ WITH ] <replac
3333
| REPLICATION | NOREPLICATION
3434
| BYPASSRLS | NOBYPASSRLS
3535
| CONNECTION LIMIT <replaceable class="parameter">connlimit</replaceable>
36-
| [ ENCRYPTED ] PASSWORD '<replaceable class="parameter">password</replaceable>'
36+
| [ ENCRYPTED ] PASSWORD '<replaceable class="parameter">password</replaceable>' | PASSWORD NULL
3737
| VALID UNTIL '<replaceable class="parameter">timestamp</replaceable>'
3838
| IN ROLE <replaceable class="parameter">role_name</replaceable> [, ...]
3939
| IN GROUP <replaceable class="parameter">role_name</replaceable> [, ...]

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp