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

Started by Tom Laneabout 13 years ago1 messagescomitters

tgl@sss.pgh.pa.us

about 13 years ago

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_2_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/5f4a3116865c6482f6e62f4ec4c9152053bc28ca

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

--
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers