diff options
| author | Michael Paquier <michael@paquier.xyz> | 2018-11-23 09:11:12 +0900 |
|---|---|---|
| committer | Michael Paquier <michael@paquier.xyz> | 2018-11-23 09:11:12 +0900 |
| commit | 3dab288f492d38d60a2cf02ba85c05df6e329ab1 (patch) | |
| tree | e7d6c89e732f0c74445aac7b8a9ac1ba0c542971 /doc/src/sgml/ref/create_user.sgml | |
| parent | 595220a3a3a89e5648b7b6be726502efdc9ec806 (diff) | |
Clarify documentation about PASSWORD in CREATE/ALTER ROLE
The documentation of CREATE/ALTER ROLE has been missing two things
related to PASSWORD:
- The password value provided needs to be quoted, some places of the
documentation marked the field with quotes, but not others, which led to
confusion.
- PASSWORD NULL was not provided consistently, with ENCRYPTED being not
compatible with it.
Reported-by: Steven Winfield
Author: Michael Paquier
Reviewed-by: David G. Johnston
Discussion: https://postgr.es/m/154282901979.1316.7418475422120496802@wrigleys.postgresql.org
Diffstat (limited to 'doc/src/sgml/ref/create_user.sgml')
| -rw-r--r-- | doc/src/sgml/ref/create_user.sgml | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/create_user.sgml b/doc/src/sgml/ref/create_user.sgml index a51dc50c978..198e06e7230 100644 --- a/doc/src/sgml/ref/create_user.sgml +++ b/doc/src/sgml/ref/create_user.sgml @@ -33,7 +33,7 @@ CREATE USER <replaceable class="parameter">name</replaceable> [ [ WITH ] <replac | REPLICATION | NOREPLICATION | BYPASSRLS | NOBYPASSRLS | CONNECTION LIMIT <replaceable class="parameter">connlimit</replaceable> - | [ ENCRYPTED ] PASSWORD '<replaceable class="parameter">password</replaceable>' + | [ ENCRYPTED ] PASSWORD '<replaceable class="parameter">password</replaceable>' | PASSWORD NULL | VALID UNTIL '<replaceable class="parameter">timestamp</replaceable>' | IN ROLE <replaceable class="parameter">role_name</replaceable> [, ...] | IN GROUP <replaceable class="parameter">role_name</replaceable> [, ...] |