]> granicus.if.org Git - postgresql/commit
Remove ALTER DEFAULT PRIVILEGES' requirement of schema CREATE permissions.
authorTom Lane <tgl@sss.pgh.pa.us>
Sun, 9 Jun 2013 19:26:48 +0000 (15:26 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Sun, 9 Jun 2013 19:26:48 +0000 (15:26 -0400)
commit5f4a3116865c6482f6e62f4ec4c9152053bc28ca
treeaf19982d62c34961ac8e2a3ccdb5fb5367fba821
parenta9ec978eb730e0ee9a0aa329009b15f1ead78386
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