Re: PG catalog

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Karki, Sanjay" <skarki(at)naic(dot)org>
Cc: "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: PG catalog
Date: 2024-05-24 13:57:36
Message-ID: 649061.1716559056@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Karki, Sanjay" <skarki(at)naic(dot)org> writes:
> I need to grant select on privilege in pg_catalog to user so I can connect 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

In response to

  • PG catalog at 2024-05-23 22:01:41 from Karki, Sanjay

Browse pgsql-hackers by date

  From Date Subject
Next Message Srinath Reddy Sadipiralla 2024-05-24 14:05:34 Re: Question: Why Are File Descriptors Not Closed and Accounted for PostgreSQL Backends?
Previous Message Robert Haas 2024-05-24 13:54:14 Re: First draft of PG 17 release notes