pgsql: Remove ALTER DEFAULT PRIVILEGES' requirement of schema CREATE pe - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Remove ALTER DEFAULT PRIVILEGES' requirement of schema CREATE pe
Date
Msg-id E1UllH6-0004OB-0n@gemulon.postgresql.org
Whole thread Raw
List 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
------
REL9_1_STABLE

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

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 by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Remove fixed limit on the number of concurrent AllocateFile() re
Next
From: Tom Lane
Date:
Subject: pgsql: Remove ALTER DEFAULT PRIVILEGES' requirement of schema CREATE pe