On Tue, Jul 27, 2021 at 11:29 PM Mark Dilger <mark.dil...@enterprisedb.com> wrote: > > The documentation for ALTER PUBLICATION ... OWNER TO ... claims the new owner > must have CREATE privilege on the database, though superuser can change the > ownership in spite of this restriction. No explanation is given for this > requirement. >
I am not aware of the original thought process behind this but current behavior seems reasonable because if users need to have CREATE privilege on the database while Create Publication, the same should be true while we change the owner to a new owner. Basically, at any point in time, the owner of the publication should have CREATE privilege on the database which contains the publication. -- With Regards, Amit Kapila.
