]> 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:55 +0000 (15:26 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Sun, 9 Jun 2013 19:26:55 +0000 (15:26 -0400)
commitaee8a60c7232cc048e00a704fca49730a722432a
treecd8afdc844250663d33165e25caafbb821ab541e
parent8c3fdbb56e8ab404bbd4d919c2cc53ca4b031516
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