Remove ALTER DEFAULT PRIVILEGES' requirement of schema CREATE permissions.
authorTom Lane <tgl@sss.pgh.pa.us>
Sun, 9 Jun 2013 19:26:40 +0000 (15:26 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Sun, 9 Jun 2013 19:26:40 +0000 (15:26 -0400)
commitf3839ea117fba6fdb69c75a1fe145aa86a4c8ae3
treea9f477f972f6897d5b1fef01a1c4eaa1b93fd29e
parent007556bf08e6153c442fe3742adb3685fca3a0e0
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.
doc/src/sgml/ref/alter_default_privileges.sgml
src/backend/catalog/aclchk.c