On Tue, Jul 27, 2021 at 11:29 PM Mark Dilger
<mark.dilger@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.