On Mon, Jul 9, 2018 at 3:39 PM Haribabu Kommi <kommi.harib...@gmail.com> wrote:
> > On Mon, Jul 9, 2018 at 12:24 PM Michael Paquier <mich...@paquier.xyz> > wrote: > >> On Fri, Jul 06, 2018 at 05:10:18PM -0400, Alvaro Herrera wrote: >> > Ugh, it's true :-( >> > >> https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=25fff40798fc4ac11a241bfd9ab0c45c085e2212#patch8 >> > >> > Dave, Simon, any comments? >> >> The offending line: >> contrib/pg_stat_statements/pg_stat_statements--1.4--1.5.sql: >> GRANT EXECUTE ON FUNCTION pg_stat_statements_reset() TO pg_read_all_stats; >> >> This will need a new version bump down to REL_10_STABLE... >> > > Hearing no objections, attached patch removes all permissions from PUBLIC > as before this change went in. Or do we need to add command for revoke only > from pg_read_all_stats? > Revoke all doesn't work, so patch updated with revoke from pg_read_all_stats. Regards, Haribabu Kommi Fujitsu Australia
0001-Revoke-pg_stat_statements_reset-permissions_v2.patch
Description: Binary data