Re: How to control pg_catalog results for each users? - Mailing list pgsql-general

From Laurenz Albe
Subject Re: How to control pg_catalog results for each users?
Date
Msg-id 564d8a38d11cee5f490cc0a40baf322fc884ed8a.camel@cybertec.at
Whole thread Raw
In response to How to control pg_catalog results for each users?  (hirose shigeo(廣瀬 繁雄 □SWC○ACT) <shigeo.hirose@toshiba.co.jp>)
Responses Re: How to control pg_catalog results for each users?
List pgsql-general
On Mon, 2023-01-30 at 14:00 +0900, hirose shigeo(廣瀬 繁雄 □SWC○ACT) wrote:
> all users can get the all of table name , table structure and other
> information from pg_catalog, which is considered a security problem.

The belief that restricting that will improve security goes by the name
of "security by obscurity", which is usually not considered robust.

Yours,
Laurenz Albe



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to control pg_catalog results for each users?
Next
From: Venkata B Nagothi
Date:
Subject: Question on Logical Replication