]> 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:27:00 +0000 (15:27 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Sun, 9 Jun 2013 19:27:00 +0000 (15:27 -0400)
commit1476a94a48eec20b5884a0a2043aa28204155d33
tree5278472d0c03f056cc9dae1c138b11c172b75e81
parent489be9c87e7eab07c0cadd1be86bfaa174532c87
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