From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Karki, Sanjay" <skarki@naic.org>
cc: "pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>
Subject: Re: PG catalog
In-reply-to: <PH0PR22MB3882F0C784A6AC48800C0BEEA2F42@PH0PR22MB3882.namprd22.prod.outlook.com>
References: <PH0PR22MB3882F0C784A6AC48800C0BEEA2F42@PH0PR22MB3882.namprd22.prod.outlook.com>
Comments: In-reply-to "Karki, Sanjay" <skarki@naic.org>
	message dated "Thu, 23 May 2024 22:01:41 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <649060.1716559056.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Fri, 24 May 2024 09:57:36 -0400
Message-ID: <649061.1716559056@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/649061.1716559056%40sss.pgh.pa.us>
Precedence: bulk

"Karki, Sanjay" <skarki@naic.org> writes:
> I need to grant select on privilege in pg_catalog to user so I can conne=
ct via Toad Data point ,

Why do you think you need to do that?  Most catalogs have public
select privilege already, and for the ones that don't, there are
very good reasons why not.  I don't know what "Toad Data point"
is, but if it thinks it needs more privilege than is normally
granted, you should be asking very pointed questions about why
and why that shouldn't be considered a security breach.

(Usually we get complaints that the default permissions on the
catalogs are too loose, not too tight.)

			regards, tom lane