On Fri, Dec 3, 2021 at 10:37 PM Mark Dilger <mark.dil...@enterprisedb.com> wrote: > > > On Dec 2, 2021, at 1:29 AM, Amit Kapila <amit.kapil...@gmail.com> wrote: > > > > If we want to maintain the property that subscriptions can only be > > owned by superuser for your first version then isn't a simple check > > like ((!superuser()) for each of the operations is sufficient? > > As things stand today, nothing prevents a superuser subscription owner from > having superuser revoked. The patch does nothing to change this. >
I understand that but won't that get verified when we look up the information in pg_authid as part of superuser() check? -- With Regards, Amit Kapila.