Amit Kapila <amit.kapil...@gmail.com> writes:
> 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.
I think that for most (all?) forms of ALTER, we say that you need the same
privileges as you would need to drop the existing object and create a new
one with the new properties. From the standpoint of the privilege
system, ALTER is just a shortcut for that.
regards, tom lane
