No PUBLIC access by default?

Поиск
Список
Период
Сортировка
От Peter Fein
Тема No PUBLIC access by default?
Дата
Msg-id 42FB8ACC.5010601@pobox.com
обсуждение исходный текст
Ответы Re: No PUBLIC access by default?  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-general
Hi all-

Is there any way to disable PUBLIC access by default?  When I create a
new object (table, function, etc.), it has no ACL, as expected.
However, the first time I run:

GRANT ALL ON FUNCTION foo() to GROUP developers;

Postgress seems to do:

GRANT ALL ON FUNCTION foo() to PUBLIC;

I assume this is b/c no ACL is equivalent to PUBLIC access & this gets
included when adding specific privileges.

I want *no* PUBLIC access to anything by default for security reasons.
Is there a way to prevent this behavior?

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

Предыдущее
От: "Ed L."
Дата:
Сообщение: Re: insert performance riddle
Следующее
От: "Ed L."
Дата:
Сообщение: Re: insert performance riddle