On Thu, Oct 29, 2015 at 10:31 PM, David Fetter <da...@fetter.org> wrote: > Had this been part of the original ALTER DEFAULT PRIVILEGES patch, > those privileges would simply have been applied. Since it wasn't, I'm > ass-u-me'ing that changing the default behavior to that is going to > cause (possibly legitimate) anxiety.
The word "applied" is not very clear here. You want to revoke all existing privileges and then regrant whatever the default privileges would have been given the new owner? That might be a reasonable thing to have a command for, but doing it automatically on an owner change does not sound like a good idea. That could be very surprising behavior. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
