Stephen Frost <sfrost@snowman.net> writes:
> There was much discussion of being able to have 'FOR ALL ROLES' or
> similar for ALTER DEFAULT PRIVILEGES when it went in, but there was a
> lot of concern about one user getting to define the default privileges
> for objects created by some other user.
Yeah, it's hard to see how you could allow such a command to anybody
but a superuser.
regards, tom lane