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
Дата
Msg-id CAKFQuwZO-cbzeZ0m4w+pToB0LuvL-YrkGv7g-i-+xamxY-UprA@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, Nov 30, 2022 at 3:35 PM 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.


I'd mention the ownership variant and suggest using the AUTHORIZATION clause, with an explicit example.

CREATE SCHEMA role_name AUTHORIZATION role_name;

David J.

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

Предыдущее
От: Isaac Morland
Дата:
Сообщение: Re: pgsql: Revoke PUBLIC CREATE from public schema, now owned by pg_databas
Следующее
От: David Rowley
Дата:
Сообщение: Re: Non-decimal integer literals