User with BYPASSRLS privilege can't change password

Поиск
Список
Период
Сортировка
От Wolfgang Walther
Тема User with BYPASSRLS privilege can't change password
Дата
Msg-id a5548a9f-89ee-3167-129d-162b5985fcf8@technowledgy.de
обсуждение исходный текст
Ответы Re: User with BYPASSRLS privilege can't change password
Список pgsql-bugs
Hi,

observed on PG12.4:

CREATE USER alice;
SET ROLE alice;
ALTER USER alice PASSOWRD 'x';
-- works

RESET ROLE;

CREATE USER bob BYPASSRLS;
SET ROLE bob;
ALTER USER bob PASSWORD 'x';
-- ERROR: must be superuser to change bypassrls attribute

I would expect bob to be able to change his password here.

Best

Wolfgang



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