CREATE/ALTER ROLE with NULL password

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема CREATE/ALTER ROLE with NULL password
Дата
Msg-id 154282901979.1316.7418475422120496802@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: CREATE/ALTER ROLE with NULL password  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/11/sql-alterrole.html
Description:

When creating a role with no password, or altering a role to remove its
password, the ENCRYPTED clause must not be present.
The current synopsis for CREATE / ALTER ROLE give one of the allowed options
as:
[ ENCRYPTED ] PASSWORD 'password'
and the current documentation for CREATE ROLE says:
"The ENCRYPTED keyword has no effect, but is accepted for backwards
compatibility."

I think it might be worth explicitly specifying the password-blanking form
for both commands as a new option in their synopses, e.g.:

"
CREATE ROLE name [ [ WITH ] option [ ... ] ]

where option can be:

      SUPERUSER | NOSUPERUSER
    | CREATEDB | NOCREATEDB
    ...
    | [ ENCRYPTED ] PASSWORD 'password' | PASSWORD NULL
    ...
"

Also, there is inconsistency of quoting of 'password' in the synopsis for
CREATE/ALTER ROLE (has quotes) vs. their respective parameters sections (no
quotes).

В списке pgsql-docs по дате отправления:

Предыдущее
От: Jürgen Purtz
Дата:
Сообщение: First SVG graphic
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Phrasing to consider (non-technical)