Re: pgsql: Revoke PUBLIC CREATE from public schema, now owned by pg_databas

Поиск
Список
Период
Сортировка
От Isaac Morland
Тема Re: pgsql: Revoke PUBLIC CREATE from public schema, now owned by pg_databas
Дата
Msg-id CAMsGm5fGPACXaWajuh4EqoaDuf4Z_3Z7qf+BDzDENN8-FH1iGw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pgsql: Revoke PUBLIC CREATE from public schema, now owned by pg_databas  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Дерево обсуждения
On Wed, 30 Nov 2022 at 17:35, Tom Lane <tgl@sss.pgh.pa.us> wrote:

BTW, is "create a schema with the same name" sufficient detail?
You have to either make it owned by that user, or explicitly
grant CREATE permission on it.  I'm not sure if that detail
belongs here, but it feels like maybe it does.

It might be worth mentioning AUTHORIZATION. The easiest way to create an appropriately named schema for a user is "CREATE SCHEMA AUTHORIZATION username".

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pgsql: Revoke PUBLIC CREATE from public schema, now owned by pg_databas
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: pgsql: Revoke PUBLIC CREATE from public schema, now owned by pg_databas