Re: [PATCH] Add regress test for pg_read_all_stats role
Michael Paquier <michael@paquier.xyz>
From: Michael Paquier <michael@paquier.xyz>
To: Alexandra Ryzhevich <aryzhevich@google.com>
Cc: pgsql-hackers@postgresql.org, Vladimir Rusinov <vrusinov@google.com>, Dmitriy Potapov <atomsk@google.com>
Date: 2018-09-26T06:29:16Z
Lists: pgsql-hackers
On Fri, Aug 24, 2018 at 03:37:17PM +0100, Alexandra Ryzhevich wrote: > CONNECT ON DATABASE privilege is granted to public by default (so > all users by default can select pg_database_size()) and > REVOKE CONNECT ... FROM <username> command doesn't impact > user's privileges. The only way to revoke connect privilege from user > is to revoke it from public. That's why maybe it will be less harmful > just to remove pg_database_size tests at all. But will it be better to > remove pg_tablespace_size() tests also? if possible costs are more > harmful than not testing this code path then I'll remove these tests > also. Sorry for the delay, Alexandra, and thanks for the new version. I have removed the tests related to pg_tablespace_size as they are costly and those for vacuum_cost_delay as we didn't gain more with those tests. The rest has been committed, which makes a good first cut. -- Michael
Commits
-
Add basic regression tests for default monitoring roles
- f535d5f0c13c 12.0 landed