Date: Fri, 23 Feb 2018 23:09:26 +0900
From: Michael Paquier <michael@paquier.xyz>
To: jobyjc@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: pg_hba_file_rules permission issue
Message-ID: <20180223140926.GC9580@paquier.xyz>
References: <151937888789.1456.18376747263583744706@wrigleys.postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="Qrgsu6vtpU/OV/zm"
Content-Disposition: inline
In-Reply-To: <151937888789.1456.18376747263583744706@wrigleys.postgresql.org>
Precedence: bulk


--Qrgsu6vtpU/OV/zm
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Fri, Feb 23, 2018 at 09:41:27AM +0000, PG Doc comments form wrote:
> According to the documentation, I assume normal users will be able to view
> pg_hba_file_rules once they are granted select privileges. But for the
> privileged user it's giving following error while trying to view records:
>=20
> ERROR:  permission denied for function pg_hba_file_rules
> SQL state: 42501

I think that you need as well execution rights on pg_hba_file_rules() to
give access to it.
--
Michael

--Qrgsu6vtpU/OV/zm
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlqQIJYACgkQnvQgOdby
QH0u8w//TKp50DlbfIW6AslkWix4TmUCBtZ7PSMYKHfxM+Mz+GrvexzFCZMG1PQ8
cFY/GCOr2aq1kFBBL3yHh1wqDXaapi8xAxrZ5h46MHpIohKhHy4rTZCKp55azOVB
9eKWxZi1YPaWlZq/e9Bp0SmiMWLu/4TUzy9kyuPf5Vj/da1brScB1dqUrAsIp/JW
WKFTiJPFLuZKruEotBMZyCbc32j0l5Rsm0aSUTjkRWBtE3LwZRy2XxgxsFaOQSH4
4cwXjONAk+nDXXW49lLUFFgpMiSSU3b/iyOeGW+YaaON/D+wgNJctDhzFl1R9U1q
Zs5bBKNGEBJ2zIwqd88t3drDfSrOkJD96sMRKMmITszH3DdZwjwT4RFkkchuDAUC
jlo77brNY+8dlSg6OjLeYFXMrSPytg/iLbG3ijQS0OGHUddRZn2L749/kR2un0be
i5j5Rh4vegEW1JKE9h4j4V5T6gCu6DZTToXuPUKvuaod9jZOxVBwXC9FaHyteNMX
j2mOmOkBDg5xSCtiDq7rQ3jCwjR7rgElsZngR1xVZbZRU+s085BzYNBoussaERdh
GMqOabGB3IaVoxFWfb9L+rXn9/rfB81OMza5H0wits9D7grOJM6rV88S1j6TJR+a
EA+VNc304Dvcffj6bfalHl1Mu/ymBBnSq/7c3xJC2VvZ57ugT1M=
=sSLW
-----END PGP SIGNATURE-----

--Qrgsu6vtpU/OV/zm--