Re: Proposal: Allow user with pg_monitor role to call pg_stat_reset* functions

2022-11-21 Thread Bharath Rupireddy
On Tue, Nov 22, 2022 at 2:15 AM Andres Freund wrote: > > Hi, > > On 2022-11-21 00:16:20 -0800, sirisha chamarthi wrote: > > At present, calling pg_stat_reset* functions requires super user access > > unless explicitly grant execute permission on those. In this thread, I am > > proposing to grant

Re: Proposal: Allow user with pg_monitor role to call pg_stat_reset* functions

2022-11-21 Thread Julien Rouhaud
On Mon, Nov 21, 2022 at 03:47:38PM -0500, Robert Haas wrote: > On Mon, Nov 21, 2022 at 3:45 PM Andres Freund wrote: > > On 2022-11-21 00:16:20 -0800, sirisha chamarthi wrote: > > > At present, calling pg_stat_reset* functions requires super user access > > > unless explicitly grant execute

Re: Proposal: Allow user with pg_monitor role to call pg_stat_reset* functions

2022-11-21 Thread Robert Haas
On Mon, Nov 21, 2022 at 3:45 PM Andres Freund wrote: > On 2022-11-21 00:16:20 -0800, sirisha chamarthi wrote: > > At present, calling pg_stat_reset* functions requires super user access > > unless explicitly grant execute permission on those. In this thread, I am > > proposing to grant execute on

Re: Proposal: Allow user with pg_monitor role to call pg_stat_reset* functions

2022-11-21 Thread Andres Freund
Hi, On 2022-11-21 00:16:20 -0800, sirisha chamarthi wrote: > At present, calling pg_stat_reset* functions requires super user access > unless explicitly grant execute permission on those. In this thread, I am > proposing to grant execute on them to users with pg_monitor role > permissions. This

Proposal: Allow user with pg_monitor role to call pg_stat_reset* functions

2022-11-21 Thread sirisha chamarthi
Hi Hackers, At present, calling pg_stat_reset* functions requires super user access unless explicitly grant execute permission on those. In this thread, I am proposing to grant execute on them to users with pg_monitor role permissions. This comes handy to the monitoring users (part of pg_monitor