Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ctFC2-0001LM-71 for pgsql-hackers@arkaria.postgresql.org; Wed, 29 Mar 2017 15:07:26 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1ctFC1-00039x-Pp for pgsql-hackers@arkaria.postgresql.org; Wed, 29 Mar 2017 15:07:25 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1ctFAT-0006BR-Ib for pgsql-hackers@postgresql.org; Wed, 29 Mar 2017 15:05:49 +0000 Received: from tamriel.snowman.net ([72.66.115.51]) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ctFAN-00048n-Qp for pgsql-hackers@postgresql.org; Wed, 29 Mar 2017 15:05:45 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 37E285F796; Wed, 29 Mar 2017 11:05:13 -0400 (EDT) Date: Wed, 29 Mar 2017 11:05:13 -0400 From: Stephen Frost To: Dave Page Cc: Robert Haas , Mark Dilger , Peter Eisentraut , PostgreSQL Hackers Subject: Re: Monitoring roles patch Message-ID: <20170329150513.GJ9812@tamriel.snowman.net> References: <20170328173721.GF9812@tamriel.snowman.net> <20170328182246.GG9812@tamriel.snowman.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="v4qTYtjyOj3SMemr" Content-Disposition: inline In-Reply-To: X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/3.13.0-91-generic (x86_64) X-Uptime: 11:04:46 up 263 days, 16:29, 26 users, load average: 0.11, 0.11, 0.08 User-Agent: Mutt/1.5.21 (2010-09-15) X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org --v4qTYtjyOj3SMemr Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Dave, * Dave Page (dpage@pgadmin.org) wrote: > OK, so essentially what I did, except s/pg_read_all_stats/pg_read_all_queries ? Yup. > So pgstattuple, pg_sfreespacemap, pg_visibility and pgrowlocks to be > allowed access from members of pg_stat_scan_tables, which in turn is > granted to pg_monitor? Yes. Thanks! Stephen --v4qTYtjyOj3SMemr Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJY280oAAoJEO1sijiDR2RVZKsP/A5mClB4UM8HhCeD6LxnR2Vz uepzDIEitqFAoynqDks39N4nFa08ER6WcydhWfTGYisgfSCjDTFMU0i9BWhTIoX4 8P4dUhuo4wx4CXiW5GKNfNr4ybF7dPTQ1YHCIntO3qnlChMoyUTmxfOvZp67iddU MWwegDA2pFWBi94Ox+7aM+hk/4JqDYIkNFwx4FIjpc1tFQeVi2nLUcrzAorQZJgW dJ92cR5B0LZFSOpUpYuAj+QO6FqoFi++U+kffQHVvp6BOm+mOaTHW3g9Essy3AQm A3//NutdNCSukVrEWV3/Eb4shGLhYWhredLKeUggSECOIHiEhvsMC+JaVDpp0rTt ITreOXZ3cZXMynQR8/3+5APt+T+n/C6b46g5UmvDFC/5QKzh9w52oxerP0Ag8Ni2 HdiKEsPTUL6ms6UVbA2Wy1rAA7AMCuoZyGeCPXqVM+Sfu5i+hITuZPD/qsijj6jw qw/HBN5Cf6MjRitknUSRfd/J2N0OG9qlRMmieyuDDu42BUS17xSSnrTjA9JurKFk N8AQuDxyyxQSj/btQZaOWKgKVtEV4xagsirmDWPvcZ31IgE53Kz51t4Z+99VVTaU lGHEFM20fbwE7XYx8cSko/IfYeJ/wM8JiXIzpdDIVqY93ZAdxXhdDXhW/lAXiKnw 6Y9SZtGxtDR5yQ8aO2bu =7QBH -----END PGP SIGNATURE----- --v4qTYtjyOj3SMemr--