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

From Ron
Subject Re: How to control pg_catalog results for each users?
Date
Msg-id d7305b7d-9ea4-8c96-45ee-300bd7e6d344@gmail.com
Whole thread Raw
In response to Re: How to control pg_catalog results for each users?  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
On 1/30/23 02:41, Laurenz Albe wrote:
> 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.

Your description sounds a whole lot like PostgreSQL's row level security.

-- 
Born in Arizona, moved to Babylonia.



pgsql-general by date:

Previous
From: David Rowley
Date:
Subject: Re: alter table impact on view
Next
From: Laurenz Albe
Date:
Subject: Re: Does statement_timeout apply to commit?