On Wed, Aug 11, 2021 at 7:45 PM Mark Dilger <mark.dil...@enterprisedb.com> wrote: > > > On Aug 10, 2021, at 10:59 PM, vignesh C <vignes...@gmail.com> wrote: > > > > Also, the behavior of "Alter publication drop table" for which the > > user is not the owner is successful, Is this behavior correct? > > I think that dropping a table from a publication should be allowed for the > publication owner, without regard to the owner of the table. > Adding a table to a publication is different, as it exposes the contents of > the table. > .. .. > > Clearly user2 cannot modify pub1, not even with respect to user2's own table. > user1 can modify its own publication except for adding someone else's table. > This seems correct to me. >
That looks reasonable to me as well and I think we should follow the same for the schema. -- With Regards, Amit Kapila.
