Re: Grant read-only access to exactly one database amongst many

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Grant read-only access to exactly one database amongst many
Дата
Msg-id CAKFQuwZiHFtQMtD8CWiF1O-Kz8WUyZrS9CXPy4ZS18x6nQ3GsQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Grant read-only access to exactly one database amongst many  (Graham Leggett <minfrin@sharp.fm>)
Список pgsql-hackers
On Monday, February 5, 2024, Graham Leggett <minfrin@sharp.fm> wrote:

Also, how do you handle the race condition between the time a database db3 is created, and the the time all readonly users have their access revoked to db3?


You alter the default privileges for the system so PUBLIC does not get connect privileges on newly created databases.

David J.

p.s. this mailing list is for discussing patches, discussions Lon how to use the system belong on the -general list.

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

Предыдущее
От: Jim Jones
Дата:
Сообщение: Re: Patch: Add parse_type Function
Следующее
От: "David E. Wheeler"
Дата:
Сообщение: Re: Patch: Add parse_type Function