pgsql: Remove ALTER DEFAULT PRIVILEGES' requirement of schema CREATE pe

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: Remove ALTER DEFAULT PRIVILEGES' requirement of schema CREATE pe
Дата
Msg-id E1UllH5-0004O5-Uj@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Remove ALTER DEFAULT PRIVILEGES' requirement of schema CREATE permissions.

Per discussion, this restriction isn't needed for any real security reason,
and it seems to confuse people more often than it helps them.  It could
also result in some database states being unrestorable.  So just drop it.

Back-patch to 9.0, where ALTER DEFAULT PRIVILEGES was introduced.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/f3839ea117fba6fdb69c75a1fe145aa86a4c8ae3

Modified Files
--------------
doc/src/sgml/ref/alter_default_privileges.sgml |    4 ++--
src/backend/catalog/aclchk.c                   |   25 ++++++++++++------------
2 files changed, 14 insertions(+), 15 deletions(-)


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Remove ALTER DEFAULT PRIVILEGES' requirement of schema CREATE pe
Следующее
От: Tom Lane
Дата:
Сообщение: pgsql: Remove unnecessary restrictions about RowExprs in transformAExpr