Re: non-superusers are allowed to drop the replication user, but are not allowed to alter or even create them, is that ok?

2021-10-01 Thread Mark Dilger
> On Sep 30, 2021, at 9:26 PM, Ashutosh Sharma wrote: > > I'll take a look at this thread in detail to see if it addresses the issue > raised here. Although from the first email it seems like the proposal is > about allowing normal users to set some of the GUC params that can only be > set

Re: non-superusers are allowed to drop the replication user, but are not allowed to alter or even create them, is that ok?

2021-09-30 Thread Ashutosh Sharma
On Thu, Sep 30, 2021 at 7:45 PM Bharath Rupireddy < bharath.rupireddyforpostg...@gmail.com> wrote: > On Thu, Sep 30, 2021 at 3:37 PM Ashutosh Sharma > wrote: > > > > Hi All, > > > > While working on one of the internal projects I noticed that currently > in Postgres, we do not allow normal users

Re: non-superusers are allowed to drop the replication user, but are not allowed to alter or even create them, is that ok?

2021-09-30 Thread Ashutosh Sharma
On Thu, Sep 30, 2021 at 8:40 PM Mark Dilger wrote: > > > > On Sep 30, 2021, at 3:07 AM, Ashutosh Sharma > wrote: > > > > While working on one of the internal projects I noticed that currently > in Postgres, we do not allow normal users to alter attributes of the > replication user. However we do

Re: non-superusers are allowed to drop the replication user, but are not allowed to alter or even create them, is that ok?

2021-09-30 Thread Mark Dilger
> On Sep 30, 2021, at 3:07 AM, Ashutosh Sharma wrote: > > While working on one of the internal projects I noticed that currently in > Postgres, we do not allow normal users to alter attributes of the replication > user. However we do allow normal users to drop replication users or to even >

Re: non-superusers are allowed to drop the replication user, but are not allowed to alter or even create them, is that ok?

2021-09-30 Thread Bharath Rupireddy
On Thu, Sep 30, 2021 at 3:37 PM Ashutosh Sharma wrote: > > Hi All, > > While working on one of the internal projects I noticed that currently in > Postgres, we do not allow normal users to alter attributes of the replication > user. However we do allow normal users to drop replication users or t

non-superusers are allowed to drop the replication user, but are not allowed to alter or even create them, is that ok?

2021-09-30 Thread Ashutosh Sharma
Hi All, While working on one of the internal projects I noticed that currently in Postgres, we do not allow normal users to alter attributes of the replication user. However we do allow normal users to drop replication users or to even rename it using the alter command. Is that behaviour ok? If ye