Postgres Pro
Downloads
Home   >   mailing lists

[PATCH] Add regress test for pg_read_all_stats role - Mailing list pgsql-hackers

From Alexandra Ryzhevich
Subject [PATCH] Add regress test for pg_read_all_stats role
Date
Msg-id CAOt4E5TMMyvYztp6iLjC+6Z85_eNfBVcv+6_SXqgv_0r3_Nztg@mail.gmail.com
Whole thread Raw
Responses Re: [PATCH] Add regress test for pg_read_all_stats role
List pgsql-hackers
Tree view
Hello,

I have noticed that there is no regression tests for default monitoring roles such as pg_read_all_stats.

In this patch the test called defroles is added. It tests permissions of pg_read_all_stats role to query database size without CONNECT permission on it, to query tablespace size without CREATE permission on it, and to read "query" column of pg_stat_activity table without SUPERUSER privilege.

Best regards,
Alexandra Ryzhevich
Attachment

pgsql-hackers by date:

Previous
From: Pavel Luzanov
Date:
Subject: Re: doc - add missing documentation for "acldefault"
Next
From: Alvaro Herrera
Date:
Subject: Page freezing, FSM, and WAL replay