Home > mailing lists

Revoke execution permission of pg_stat_statements_reset() frompg_read_all_stats role - Mailing list pgsql-hackers

From	Haribabu Kommi
Subject	Revoke execution permission of pg_stat_statements_reset() frompg_read_all_stats role
Date	September 24, 2018 07:08:14
Msg-id	CAJrrPGf5fCnKqXObpwGN9nMyD--tzOf-7LFCJiz59Z1wJ5qj9A@mail.gmail.com Whole thread Raw
Responses	Re: Revoke execution permission of pg_stat_statements_reset() frompg_read_all_stats role
List	pgsql-hackers

Tree view

[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

Attachment

0001-Revoke-pg_stat_statements_reset-permissions_v2.patch

pgsql-hackers by date:

From: Thomas Munro
Date: 24 September 2018, 06:27:13
Subject: Re: Missing const in DSA.

From: Haribabu Kommi
Date: 24 September 2018, 07:13:43
Subject: Re: New function pg_stat_statements_reset_query() to reset statisticsof a specific query

Revoke execution permission of pg_stat_statements_reset() frompg_read_all_stats role - Mailing list pgsql-hackers

Attachment

Previous

Next