prevent non-superuser terminate bgworker running as superuser

Поиск
Список
Период
Сортировка
От Hemanth Sandrana
Тема prevent non-superuser terminate bgworker running as superuser
Дата
Msg-id CAAB6CY5H7Yp3jfMWP25tA0AMYbY5eSogS7GNbGEXN0KRmmxy1g@mail.gmail.com
обсуждение исходный текст
Ответы Re: prevent non-superuser terminate bgworker running as superuser  (Jelte Fennema <postgres@jeltef.nl>)
Список pgsql-hackers
Hi All,

Currently, BackgroundWorker connected to a database by calling
BackgroundWorkerInitializeConnection with username as NULL can be
terminated by non-superuser with pg_signal_backend privilege. When the
username is NULL the bgworker process runs as superuser (which is
expected as per the documentation -
https://www.postgresql.org/docs/current/bgworker.html ), but can the
non-superuser (with pg_signal_backend) terminate this superuser owned
process?
We (Mahendrakar and Myself) think that this is a bug and proposing a
fix that sets MyProc->roleId to BOOTSTRAP_SUPERUSERID, similar to
InitializeSessionUserId, to prevent non-superuser terminating it.

Please let us know your comments.

Thanks,
Hemanth Sandrana

Вложения

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: controlling meson's parallelism (and some whining)
Следующее
От: Robert Haas
Дата:
Сообщение: Re: New WAL record to detect the checkpoint redo location