| From: | Alexandra Ryzhevich <aryzhevich(at)google(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | Vladimir Rusinov <vrusinov(at)google(dot)com>, Dmitriy Potapov <atomsk(at)google(dot)com> |
| Subject: | [PATCH] Add regress test for pg_read_all_stats role |
| Date: | 2018-08-02 17:25:14 |
| Message-ID: | CAOt4E5TMMyvYztp6iLjC+6Z85_eNfBVcv+6_SXqgv_0r3_Nztg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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 | Content-Type | Size |
|---|---|---|
| 0001-Add-regress-test-for-pg_read_all_stats-role.patch | text/x-patch | 5.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2018-08-02 17:28:57 | Page freezing, FSM, and WAL replay |
| Previous Message | Pavel Luzanov | 2018-08-02 17:23:03 | Re: doc - add missing documentation for "acldefault" |