[spawning a new thread] In commit 25fff40798 the execute permission of pg_stat_statements_reset() is provided to pg_read_all_stats role in [1].
The execute permissions grant to pg_read_all_stats concern is raised in [2] during the discussion of supporting different methods of reset the stats, instead of resetting all. Here I attached the patch that reverts the permission grant as per the discussion in [3]. [1] - https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=25fff40798fc4ac11a241bfd9ab0c45c085e2212#patch8 [2] - https://www.postgresql.org/message-id/CAHGQGwE8Roydg-bVweK8GjpOipWh3rAAstMqoUfz7qBFrs8Tuw%40mail.gmail.com [3] - https://www.postgresql.org/message-id/CAJrrPGdre9CqaHsbgtsc3LmJSRFg41fOZ%2BZVpX9zu3D1fGqAeQ%40mail.gmail.com Regards, Haribabu Kommi Fujitsu Australia
0001-Revoke-pg_stat_statements_reset-permissions_v2.patch
Description: Binary data
